/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 vote192 views1 answer
Change form background image vb
VBA
0 vote205 views1 answer
Vbnet round to nearnest thousand
VBA
1 vote179 views1 answer
Excel vba saveas force overwrite
VBA
0 vote198 views1 answer
Excel vba open browser
VBA
7 votes205 views1 answer
Excerl vba array to range
VBA
0 vote172 views1 answer
Vbnet display all axis labels in cahrt
VBA
0 vote227 views1 answer
Vba dictionary clear
VBA
-1 vote179 views1 answer
For i in range vba
VBA
0 vote190 views1 answer
Excel named range sum
VBA
0 vote194 views1 answer
Windows Forms dark title bar
VBA