/VBA/Excel vba how to get a range's full address including sheet name

Excel vba how to get a range's full address including sheet name

'VBA function to retrieve the full address of a range:

Function FullAddress(r As Range)
    With r
        FullAddress = "'" & .Parent.Name & "'!" & .Address
    End With
End Function

'--------------------------------------------------------------------

MsgBox FullAddress		'Displays: 'My Sheet'!$A$1:$Z$99

Source: academy.excelhero.com

Similar codes

0 vote157 views1 answer
Change form background image vb
VBA
0 vote144 views1 answer
Change whcih control a user has selected vb
VBA
0 vote161 views1 answer
Vba format currency
VBA
0 vote195 views1 answer
Vba excel parser xml
VBA
25 votes292 views2 answers
Excel vba folder exist
VBA
0 vote157 views1 answer
Label de tableau dans des label.text en VBA
VBA
0 vote109 views1 answer
Vba code to remove leading and trailing spaces
VBA
0 vote150 views1 answer
Vbscript for loop
VBA
0 vote164 views1 answer
Excel vba set cell value to empty
VBA
0 vote150 views1 answer
Get month number from month name vbnet
VBA