/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 vote124 views1 answer
Vba add month to date
VBA
0 vote121 views1 answer
Excel vba hide columns
VBA
0 vote128 views1 answer
Excel vba set cell value to empty
VBA
0 vote154 views1 answer
Windows Forms dark title bar
VBA
1 vote126 views2 answers
Get all column names from excel vba
VBA
1 vote112 views1 answer
How to do error handling in access vba
VBA
18 votes175 views3 answers
Excel-vba make integer
VBA
0 vote125 views1 answer
Vbs expand env var
VBA
0 vote122 views1 answer
Remove frist letter from string vbnet
VBA
3 votes127 views1 answer
Extract word in a text in excel
VBA