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
