UsedRange.Columns.Count

For creating two dimensional dynamic array in excel, follow the steps below:

• Declare the two dimensional Array
• Resize the array
• Store values in array
• Retrieve values from array

Read more