/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 vote162 views1 answer
Columns dont autoresize on program start vb.net
VBA
1 vote149 views1 answer
Excel vba Refreshing all pivot tables in workbook
VBA
0 vote159 views1 answer
Vba listbox remove all items
VBA
0 vote154 views1 answer
Sort dictionary by key vba
VBA
0 vote181 views1 answer
Check if cell is dbnullvb.net
VBA
0 vote146 views1 answer
Vbscript for loop
VBA
5 votes166 views1 answer
Excel vba second byte from INTEGER
VBA
1 vote142 views1 answer
Vba declare api 64 bit 32 bit
VBA
0 vote144 views1 answer
Vbnet get file name from path
VBA
0 vote186 views1 answer
Set datetimepicker value to null vb
VBA