/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 vote292 views1 answer
Vbnet add new ecel sheet
VBA
0 vote432 views1 answer
Vba change active sheet
VBA
0 vote296 views1 answer
Vba file size
VBA
8 votes359 views1 answer
Excel vba make integer
VBA
0 vote287 views1 answer
Vb test if reference is null
VBA
0 vote352 views1 answer
If statement vdhl
VBA
5 votes881 views1 answer
Vlookup vba
VBA
1 vote324 views1 answer
Excel vba Refreshing all pivot tables in workbook
VBA
0 vote337 views1 answer
Tester si une case est vide vba
VBA
-1 vote363 views1 answer
Vba sendkeys
VBA