/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

5 votes182 views1 answer
Excel vba highlight cells using the hex color value within the cells
VBA
1 vote170 views1 answer
Excel vba force recalculation
VBA
0 vote168 views1 answer
Delete rows in excel vba code
VBA
0 vote166 views1 answer
Switch pictures with buttons vb.net
VBA
0 vote185 views1 answer
If statement vdhl
VBA
0 vote154 views1 answer
Replace spaces with underscores vbnet
VBA
0 vote169 views1 answer
Vb.net visible property dgv collumn not working
VBA
0 vote243 views1 answer
Application.ExecutablePath VB.NET
VBA
1 vote154 views1 answer
Excel vba convert cells(1,1) into A1 and vice versa
VBA
0 vote182 views4 answers
Vgrive,deb
VBA