/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 vote168 views1 answer
VBA Sleep Snippet
VBA
0 vote157 views1 answer
Find days in month vba
VBA
0 vote170 views1 answer
Pivot data source not accepting table named range vba
VBA
0 vote161 views1 answer
Excel vba scroll to cell
VBA
0 vote172 views1 answer
Arq linux
VBA
0 vote199 views1 answer
Vbnet check if string is only numbers
VBA
1 vote191 views1 answer
Excel vba convert text YYYYMMDD to date
VBA
0 vote157 views1 answer
Enter into cells data grid view
VBA
0 vote158 views1 answer
Vbnet get file name from path
VBA
5 votes177 views1 answer
Excel vba low byte from INTEGER
VBA