Turn your Excel Spreadsheet into a powerful online database application with a few clicks

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
No comments yet.