/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

2 votes232 views1 answer
Date format for ms chart vb.net
VBA
0 vote241 views1 answer
Remove series name from legendvbnet
VBA
4 votes253 views1 answer
Excel vba Imitating the "IN" operator from python
VBA
3 votes269 views2 answers
Vba date to string
VBA
1 vote244 views1 answer
How to remove zeros in excel
VBA
1 vote251 views1 answer
Set font for ms chart vb.net
VBA
1 vote182 views1 answer
Ms access open form to new record
VBA
0 vote263 views1 answer
Amd64 vs arm64 linux
VBA
0 vote240 views1 answer
How to carry text to the next line in a label in vb.net
VBA
0 vote247 views2 answers
Vba remove line breaks
VBA