Want to become an expert in VBA? So this is the right place for you. This blog mainly focus on teaching how to apply Visual Basic for Microsoft Excel. So improve the functionality of your excel workbooks with the aid of this blog. Also ask any questions you have regarding MS Excel and applying VBA. We are happy to assist you.

Number of columns in excel 2010 - An important fact about excel 2010

There are 16384 columns in excel 2010. Column title of last column is "XFD" 

This is how I found it by VBA code.

I wrote below code.

Sub columnLimit()

For i = 1 To 100000
    Cells(12, i).Value = i
Next i

End Sub

And run it in a worksheet. Then I got below error message.

Clicked OK and went to end of columns using scroll bar. Found the result

Contact Form


Email *

Message *