/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 vote219 views2 answers
Excel vba number format file size
VBA
0 vote212 views1 answer
Vba sort the data Z to A
VBA
0 vote213 views1 answer
Ribbon show/hide
VBA
0 vote200 views1 answer
How to set location and size of new from vb
VBA
0 vote217 views1 answer
VB Error Code BC30201
VBA
0 vote227 views1 answer
Vba multiple optional arguments
VBA
12 votes476 views1 answer
Excel vba write string to text file
VBA
0 vote222 views1 answer
Vbnet chart make 0 gridline line different color
VBA
3 votes198 views1 answer
Vba folderexists
VBA
0 vote229 views1 answer
Add Formula to Shape Text in VBA
VBA