/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 vote352 views1 answer
Reset border color textbox vba
VBA
0 vote383 views2 answers
Excel vba number format file size
VBA
1 vote360 views1 answer
Vba reverse string
VBA
3 votes356 views2 answers
Excel "vba" match last value
VBA
0 vote354 views1 answer
Excel vba disable keyboard input
VBA
0 vote280 views10 answers
Vba excel create event log
VBA
22 votes583 views1 answer
Xl vba check for folder
VBA
1 vote308 views1 answer
Vba Remove Case Sensitivity
VBA
0 vote374 views1 answer
Change form background image vb
VBA
8 votes464 views1 answer
Excel vba make a short integer from two bytes
VBA