/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 vote327 views1 answer
Vba multiple optional arguments
VBA
5 votes301 views1 answer
Vba array worksheet.index
VBA
0 vote310 views1 answer
Vba verticalalignment
VBA
0 vote319 views1 answer
Vba leading zeros in string
VBA
0 vote314 views1 answer
Vba len variant
VBA
-1 vote334 views1 answer
VBA check if a cell contains a letter or string
VBA
1 vote297 views2 answers
Excel vba password protect
VBA
1 vote323 views1 answer
How to INPUT text in shape with enter and spacein vba
VBA
0 vote343 views4 answers
Vgrive,deb
VBA
0 vote320 views1 answer
Excel vba move down to next visible cell
VBA