/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 vote215 views1 answer
Returns an array from function vba
VBA
4 votes208 views1 answer
Excel formula for last non-empty cell in a column
VBA
3 votes243 views2 answers
Vba date to string
VBA
0 vote227 views1 answer
Thread sleep vb
VBA
1 vote212 views1 answer
Excel vba first row in range
VBA
0 vote243 views1 answer
Vba listbox remove all items
VBA
0 vote194 views1 answer
Excel vba linter
VBA
1 vote175 views1 answer
Vba exit do while
VBA
0 vote218 views1 answer
Priavte sub with multiple handels find sneder
VBA
0 vote206 views1 answer
Add items to combobox vb.net
VBA