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

Get LIVE Help
Custom Excel solutions & live Excel help!
► Go to www.ExcelAutomationHelp.com
► Email Now@ExcelAutomationHelp.com
No comments yet.