VBA: Get the active cell’s Column

August 14th, 2004 | Categories: Cells, Columns & Rows | Tags: active, cell, column, VBA

-->

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

Can't get the tutorial to work for you? Need help with your code?
Get answers right away at our AE Excel Support Forums!