/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 vote281 views1 answer
Filesystemobject vba reference
VBA
12 votes291 views1 answer
Excel vba write string to text file
VBA
0 vote225 views1 answer
Add items to combobox vb.net
VBA
1 vote250 views1 answer
What does vbs stand for
VBA
0 vote250 views1 answer
How to format a textbox as date vb net
VBA
0 vote249 views1 answer
Faire appel à la mise en forme conditionnelle vba excel
VBA
0 vote246 views1 answer
Vba len variant
VBA
0 vote227 views1 answer
Vba copy paste value only
VBA
0 vote255 views1 answer
Excel vba Column Name from Column Number
VBA
5 votes249 views1 answer
Excel vba highlight cells using the hex color value within the cells
VBA