/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 vote144 views1 answer
Excel vba last row of range
VBA
0 vote140 views1 answer
Vbs expand env var
VBA
0 vote129 views1 answer
Vba DisplayGridlines
VBA
3 votes131 views1 answer
Vba folderexists
VBA
0 vote136 views1 answer
Vbnet line chart showing extra space
VBA
0 vote131 views1 answer
Excel vba formatconditions range
VBA
0 vote182 views1 answer
Vba excel do not recalculate before save
VBA
1 vote126 views1 answer
Textbox find and replace vb
VBA
0 vote170 views1 answer
Set datetimepicker value to null vb
VBA
6 votes152 views1 answer
Excel vba isalpha
VBA