/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

11 votes404 views1 answer
Excel vba How to URL encode a string
VBA
1 vote290 views1 answer
Vba reverse string
VBA
4 votes290 views1 answer
Excel vba Imitating the "IN" operator from python
VBA
-1 vote278 views1 answer
For i in range vba
VBA
1 vote307 views1 answer
How to remove zeros in excel
VBA
0 vote298 views1 answer
Vba compare strings
VBA
0 vote293 views1 answer
Vba change named range address
VBA
5 votes335 views1 answer
Excel-vba get integer high byte
VBA
0 vote277 views1 answer
Vba format currency
VBA
0 vote257 views1 answer
Excel vba concatenate range
VBA