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

VBA: Count the Columns in a Selection

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

If you ever need to count the number of Columns that were selected, use Selection.Columns.Count

Put this in a module:

Public Sub CountMyColumns()
MsgBox Selection.Columns.Count
End Sub
No comments yet.