/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 vote215 views1 answer
Vba text to general
VBA
1 vote220 views1 answer
Excel vba get column name from number
VBA
0 vote212 views1 answer
Excel vba disable screen update
VBA
0 vote216 views1 answer
Excel vba disable copy paste
VBA
1 vote236 views1 answer
Extract the second word in a text in excel
VBA
0 vote254 views1 answer
Vba registry settings
VBA
0 vote208 views1 answer
How to self delete a vbscript file
VBA
5 votes249 views1 answer
Excel vba tool to help with refactoring code
VBA
0 vote228 views1 answer
Vba file chooser
VBA
0 vote209 views1 answer
Le contrôle SpinButton (Toupie)
VBA