/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 vote143 views1 answer
Find if year is leap year vb
VBA
0 vote134 views1 answer
Pivot data source not accepting table named range vba
VBA
15 votes159 views1 answer
Excel vba wait
VBA
0 vote130 views1 answer
Vba word open document read only
VBA
0 vote131 views1 answer
Vba variable number of arguments
VBA
0 vote121 views1 answer
Excel vba select multiple shapes
VBA
1 vote135 views1 answer
Vba login website
VBA
0 vote137 views1 answer
Vba simple quote
VBA
0 vote120 views1 answer
How to extract a file from an ISO:
VBA
0 vote129 views2 answers
How to concatenate more than 40 lines in vba
VBA