/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 vote267 views1 answer
Vbide vbproject reference
VBA
0 vote301 views1 answer
Vba array dimensions
VBA
0 vote283 views1 answer
Backspace key has stopped working visual studio
VBA
0 vote279 views1 answer
Vba word pdf table to excel
VBA
0 vote301 views1 answer
Vbscript remove spaces from string
VBA
4 votes288 views2 answers
Vba create folder if not exist
VBA
0 vote273 views1 answer
Vba get text file content
VBA
4 votes339 views1 answer
VBA Deep Clone Dictionary
VBA
2 votes276 views1 answer
Excel vba date to string conversion
VBA
0 vote274 views1 answer
Visual basic msdos
VBA