/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 vote212 views1 answer
Hello world vb.net
VBA
2 votes280 views1 answer
Vba round number
VBA
0 vote212 views1 answer
Vb net check if file exists
VBA
0 vote218 views1 answer
Refer to resource using string variable vb.net
VBA
3 votes253 views2 answers
Vba active workbook path
VBA
0 vote216 views1 answer
Excel vba current folder
VBA
0 vote207 views1 answer
Excel vba populate array with cell values
VBA
0 vote229 views1 answer
Worksheet.pastespecial textbox
VBA
0 vote222 views1 answer
Vb test if reference is null
VBA
0 vote207 views1 answer
Vbnet get file name from path
VBA