ACTIVECELL LOCATION

[kt(uk)]

I would like to know if there is a macro command that will return the
position of the current activcell. This could either be in the format B6 or
6,2

 

[Stefi]

ActiveCell.Address(False, False)

Regards,
Stefi

„kt(uk)†ezt írta:

 

[Bernard Liengme]

Sub tryme()
MsgBox ActiveCell.Address
End Sub

best wishes