Counting Columns

Hi Charlene

In VBA if you have a range/table of data and need to know the number of columns you do the following:

1. Create a Variable to hold the number of columns value
2. Select a cell in the range
3. Use code to count the columns and save the answer in the variable. For example:

Sub NumberOfColumns()

Dim NumOfColumns As Integer

Sheets(