/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

5 votes179 views1 answer
Excel formula how to create strings containing double quotes
VBA
0 vote180 views1 answer
Vba add shape oval
VBA
0 vote183 views1 answer
VBA
VBA
0 vote176 views1 answer
Vlookup columns not next to each other
VBA
-1 vote178 views1 answer
Vba code to add new column in table
VBA
4 votes180 views1 answer
Excel vba determine number of elements in an array
VBA
0 vote192 views4 answers
How to continue formula in below line in vba code
VBA
0 vote165 views1 answer
Vb net show lines for all axis labels in chart
VBA
0 vote174 views1 answer
Limit combobox to list vba
VBA
1 vote160 views2 answers
Excel vba password protect
VBA