dale johnson
dale johnson
Programming language:VBA
2021-03-03 07:22:04
0
Q:

excel vba how to get a range's full address including sheet name

user68937
user68937
Code: VBA
2021-08-20 01:52:23 
'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
4

Tags

Related

New to Communities?

Join the community