Numeric activecell reference into VBA

[lesliglasser]

I wish to obtain numeric row and column values of a currently active cell in order to offset to another related cell.

 

[wigi]

ActiveCell.Row and ActiveCell.Column will give you these.

 

[VoG]

Try like this

Sub colrow()
MsgBox "Row" & vbTab & ActiveCell.Row & vbNewLine & "Column" & vbTab & ActiveCell.Column
End Sub

 

[lesliglasser]

Thank you - exactly what I needed!