/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

6 votes203 views1 answer
Excel vba isalpha
VBA
0 vote188 views1 answer
Vb test if reference is null
VBA
0 vote195 views1 answer
String contins in vba
VBA
0 vote202 views1 answer
Vba DisplayGridlines
VBA
9 votes408 views2 answers
Excel vba convert 2 Short integers to a Long integer
VBA
0 vote196 views1 answer
Excel last used row
VBA
0 vote178 views1 answer
Vb window.minimize
VBA
1 vote190 views1 answer
Excel vba How to determine if a date falls on the weekend?
VBA
0 vote185 views1 answer
Excel vba calculate
VBA
3 votes198 views1 answer
Vba post request json
VBA