/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 vote162 views1 answer
Replace spaces with underscores vbnet
VBA
0 vote182 views1 answer
How to get the value of optionbutton in vba
VBA
9 votes330 views2 answers
Excel vba convert 2 Short integers to a Long integer
VBA
3 votes213 views2 answers
Vba date to string
VBA
0 vote198 views1 answer
Vba dictionary clear
VBA
0 vote173 views1 answer
Vbs
VBA
1 vote181 views1 answer
If inputbox cancel vba
VBA
0 vote151 views1 answer
How to make a if statement with vbs
VBA
0 vote178 views1 answer
Convert Seconds to HH:MM:SS in VB.Net
VBA
0 vote184 views1 answer
Find database connection string vb
VBA