/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 vote147 views1 answer
Excel vba protect shapes
VBA
0 vote132 views1 answer
Write listbox to text file vb.net
VBA
0 vote126 views1 answer
Discern between file and folder given path vb.net
VBA
8 votes261 views1 answer
Excel vba make word from bytes
VBA
1 vote117 views1 answer
Vba delete array element
VBA
0 vote133 views1 answer
Vba registry settings
VBA
0 vote120 views1 answer
Vba find sub dictionary
VBA
0 vote109 views1 answer
Vba argument is set
VBA
0 vote137 views1 answer
Find if year is leap year vb
VBA
0 vote122 views1 answer
Vba sheet visible
VBA