/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 vote156 views1 answer
Vba date to unix timestamp
VBA
0 vote153 views1 answer
VB get external IP address
VBA
0 vote146 views1 answer
Excel vba show developer tab
VBA
0 vote163 views1 answer
Vbnet convert charatcer to binary
VBA
4 votes155 views1 answer
Excel vba how to reset usedrange
VBA
0 vote163 views1 answer
Pivot data source not accepting table named range vba
VBA
0 vote146 views1 answer
Excel vba disable screen update
VBA
2 votes158 views1 answer
Vba ado ace sql alias ignored for calculated column
VBA
0 vote157 views1 answer
Excel vba cell on change
VBA
0 vote166 views1 answer
Vba keep command window open
VBA