/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 vote142 views2 answers
Get all column names from excel vba
VBA
1 vote151 views1 answer
Set font for ms chart vb.net
VBA
0 vote152 views1 answer
VBA Loop to range
VBA
0 vote148 views1 answer
Vba compare strings
VBA
1 vote143 views2 answers
Vba function return array
VBA
0 vote181 views1 answer
Vb ternary
VBA
0 vote150 views1 answer
Excel vba range contains
VBA
2 votes154 views2 answers
Vba code to remove duplicates from a column
VBA
1 vote149 views1 answer
Excel vba Refreshing all pivot tables in workbook
VBA
1 vote139 views1 answer
Excel vba saveas force overwrite
VBA