/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 vote321 views1 answer
Vba exit while
VBA
0 vote310 views1 answer
Excel vba assign shortcut key to button
VBA
0 vote312 views1 answer
Docker vboxmanage not found
VBA
0 vote335 views2 answers
Get excel file from email attachment in vba
VBA
0 vote329 views1 answer
Vba simple quote
VBA
5 votes379 views1 answer
Excel vba low word from Long Integer
VBA
0 vote379 views1 answer
Programmatically copy data from one workshet to another excel
VBA
0 vote332 views1 answer
Vbs expand env var
VBA
0 vote314 views1 answer
Vb test if reference is null
VBA
0 vote351 views1 answer
Add text to Shape VBA
VBA