/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

1 vote354 views1 answer
Vba refresh pivot table
VBA
0 vote403 views1 answer
Supprimer la valeur de celule vba
VBA
1 vote340 views1 answer
Excel vba first and last row and column in range
VBA
0 vote409 views1 answer
Excel vba protect scenarios
VBA
0 vote365 views1 answer
Vba round to 2 decimals
VBA
0 vote356 views1 answer
Excel vba textbox forecolor disabled
VBA
0 vote351 views1 answer
Vba type variable
VBA
1 vote375 views1 answer
Vba ubound array 2-dimensional
VBA
0 vote356 views1 answer
Vbscript Trim
VBA
0 vote366 views1 answer
Power query M substract minimum value of column -dax
VBA