/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 vote175 views1 answer
Le contrôle SpinButton (Toupie)
VBA
0 vote199 views1 answer
Vba cell all borders
VBA
5 votes187 views1 answer
Excel vba low byte from INTEGER
VBA
1 vote179 views1 answer
Textbox find and replace vb
VBA
0 vote202 views1 answer
Vba userform textbox wrap text
VBA
0 vote183 views1 answer
Excel vba Column Name from Column Number
VBA
0 vote186 views1 answer
How to format a textbox as date vb net
VBA
5 votes131 views1 answer
Vba array worksheet.index
VBA
0 vote188 views1 answer
Vba collection contains
VBA
0 vote176 views1 answer
Change form background image vb
VBA