VBA: Get the active cell’s Column

Automate Excel

VBA: Get the active cell’s Column

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

Related posts

Posted in Cells, Columns & Rows |

Tags: , , ,

Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.