/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 vote145 views1 answer
Move bindingnavigator vb
VBA
1 vote144 views1 answer
Set font for ms chart vb.net
VBA
1 vote151 views1 answer
Export datagridview to excel vb.net
VBA
0 vote180 views1 answer
Vba userform textbox wrap text
VBA
0 vote142 views1 answer
Vba boolean to string
VBA
1 vote86 views1 answer
Vba Remove Case Sensitivity
VBA
-1 vote163 views1 answer
How save excel through visual basic
VBA
6 votes155 views1 answer
Excel vba get the path of current workbook
VBA
0 vote144 views1 answer
Vba nested dictionary
VBA
2 votes151 views1 answer
Excel vba check if string entirely alpha
VBA