/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

22 votes552 views1 answer
Excelvba check for directory
VBA
3 votes334 views2 answers
Excel "vba" match last value
VBA
0 vote315 views1 answer
Returns an array from function vba
VBA
0 vote406 views1 answer
Visual basic cmd
VBA
0 vote321 views1 answer
Excel vba disable alerts
VBA
0 vote346 views1 answer
Power query M substract minimum value of column -dax
VBA
11 votes480 views1 answer
Excel vba How to URL encode a string
VBA
0 vote353 views2 answers
Get unique random number in vb.net
VBA
0 vote317 views1 answer
Do until vb.net
VBA
0 vote334 views1 answer
Vba type
VBA