/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

1 vote203 views1 answer
Excel vba first row in range
VBA
0 vote254 views1 answer
Excel vba delete columns in range
VBA
0 vote220 views1 answer
Vb ternary
VBA
0 vote202 views1 answer
Vbnet get file name from path
VBA
0 vote221 views1 answer
Excel vba join variant array
VBA
0 vote218 views1 answer
Enable macros on opening workbook vba
VBA
0 vote232 views2 answers
VB
VBA
0 vote212 views1 answer
Excel vba unmerge sheet
VBA
0 vote194 views1 answer
Vba dropdown event
VBA
1 vote207 views1 answer
If inputbox cancel vba
VBA