/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 vote197 views1 answer
Vba border weight
VBA
2 votes226 views2 answers
Excel vba if sunday or staurday
VBA
0 vote188 views1 answer
Returns an array from function vba
VBA
1 vote191 views1 answer
Excel vba unload userform
VBA
0 vote197 views1 answer
Vbnet access System.InvalidOperationException: 'Update requires a valid UpdateCommand when passed DataRow collection with modified rows.'
VBA
3 votes203 views2 answers
Vba active workbook path
VBA
0 vote182 views1 answer
Handling a click event anywhere inside a panel vb
VBA
0 vote214 views1 answer
Vba open report
VBA
8 votes187 views1 answer
Excel vba make a short integer from two bytes
VBA
0 vote197 views1 answer
Excel R1C1 mode
VBA