/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 vote198 views1 answer
Hello world vb.net
VBA
0 vote201 views1 answer
Excel vba current folder
VBA
18 votes533 views2 answers
Vba make word from bytes
VBA
0 vote214 views1 answer
Vba simple quote
VBA
0 vote196 views1 answer
Vbnet access System.InvalidOperationException: 'Update requires a valid UpdateCommand when passed DataRow collection with modified rows.'
VBA
0 vote206 views1 answer
Switch pictures with buttons vb.net
VBA
0 vote198 views2 answers
How to concatenate more than 40 lines in vba
VBA
0 vote204 views1 answer
Excel named range sum
VBA
0 vote212 views1 answer
VB Error Code BC30201
VBA
0 vote216 views1 answer
Power query M substract minimum value of column -dax
VBA