/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 vote226 views1 answer
Vb.net visible property dgv collumn not working
VBA
1 vote222 views1 answer
Add a index column power bi
VBA
0 vote228 views1 answer
Excel vba unmerge sheet
VBA
1 vote230 views1 answer
If inputbox cancel vba
VBA
0 vote210 views1 answer
Vba remove numbers from string
VBA
0 vote241 views1 answer
Como ler subitem de um array em json usando vbnet
VBA
0 vote219 views1 answer
Vbscript remove spaces from string
VBA
0 vote230 views1 answer
Excel vba Column Name from Column Number
VBA
0 vote219 views1 answer
Excel vba hide columns
VBA
0 vote258 views1 answer
VBA Sort RossetaCode
VBA