/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 vote237 views1 answer
Vba listbox remove all items
VBA
8 votes308 views1 answer
Vba make integer
VBA
0 vote241 views1 answer
Vbnet click on dgv cells
VBA
0 vote220 views1 answer
Change whcih control a user has selected vb
VBA
0 vote217 views1 answer
Vb.net round to 2 decimal places
VBA
0 vote257 views2 answers
Get unique random number in vb.net
VBA
0 vote223 views1 answer
Vba static variable
VBA
0 vote243 views1 answer
Regex numeric digits
VBA
3 votes228 views1 answer
Excel vba change format of cell
VBA
22 votes528 views1 answer
Xlvba check for folder
VBA