/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 vote202 views1 answer
Excel vba protect shapes
VBA
2 votes185 views1 answer
Excel vba check if string entirely alpha
VBA
0 vote178 views1 answer
System.InvalidOperationException: 'Row associated with the currency manager's position cannot be made invisible.
VBA
2 votes183 views1 answer
Vba file from path
VBA
0 vote184 views2 answers
Do until loop vba
VBA
4 votes192 views1 answer
VBA Deep Clone Dictionary
VBA
0 vote159 views1 answer
Vbnet display all axis labels in cahrt
VBA
0 vote230 views1 answer
Find control with name vb
VBA
0 vote193 views1 answer
Priavte sub with multiple handels find sneder
VBA
0 vote174 views1 answer
Excel vba remove formatting from cell
VBA