/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

1 vote267 views1 answer
Excel vba convert text YYYYMMDD to date
VBA
0 vote256 views1 answer
Vba nested dictionary
VBA
3 votes246 views1 answer
Excel vba get the workbook full filename with path
VBA
1 vote239 views1 answer
Add rows to datagridview vb.net
VBA
0 vote240 views1 answer
Vba dictionary clear
VBA
0 vote260 views1 answer
Vba registry settings
VBA
0 vote205 views1 answer
Vbide vbproject reference
VBA
3 votes242 views2 answers
Excel "vba" match last value
VBA
0 vote240 views1 answer
Thread sleep vb
VBA
0 vote200 views1 answer
Vba select file in folder
VBA