VBA: Get the active cell’s Column

August 14th, 2004 | Categories: Cells, Columns & Rows | Tags: , , ,

If you need to get the active cell’s column from VBA, this should do it!

Put this in a module:

Public Sub ActiveColumn()

MsgBox ActiveCell.Column

End Sub

Leave a comment | Trackback
No comments yet.