/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 vote259 views1 answer
Le contrôle SpinButton (Toupie)
VBA
-1 vote278 views2 answers
Excel vba delete empty rows
VBA
1 vote313 views1 answer
Perform http request in vb.net
VBA
0 vote278 views1 answer
For each item in folder outlook vba
VBA
1 vote253 views1 answer
Vbscript convert ascii code to character
VBA
0 vote267 views1 answer
Vbscript Trim
VBA
0 vote255 views1 answer
Excel vba disable copy paste
VBA
1 vote258 views2 answers
Vba remove first 2 characters from string
VBA
31 votes372 views1 answer
Excel-vba how to convert a column number into an excel column
VBA
1 vote269 views1 answer
Vba delete file
VBA