Sunday, May 20, 2012

EXCEL - Count the number of rows and columns in the Sheet

When we use the Excel to record, I am curious about how many records I can put into the spreadsheet.

The following Macro can do the job.

Sub RowandColumnCount()

MsgBox Rows.Count

MsgBox Columns.Count

End Sub

My Excel version is Excel 2007.

The outputs are 1,048,576 and 16,384.

I can have 1,048,576 row of records and 16,384 column of records.

© Copyright Exceltipsandkeys All Rights Reserved.


  1. I am happy to find your distinguished way of writing the post. Now you make it easy for me to understand and implement the concept. Thank you for the post.


  2. I do believe that beauty is in the eye of the beholder. What does it really means to us? It only explains that true beauty is not in our physical aspects but in our inner aspects. In short, attitude or character because what you have shown is what people think of you. Beauty comes out naturally. Visit my site #triciajoy for some terrific offer that I am sure you can't refuse. Thanks for sharing such a wonderful article. Have a good day!

  3. Love it! Very interesting topics, I hope the incoming comments and suggestion are equally positive. Thank you for sharing this information that is actually helpful.

  4. This is a great article for my research. Keep posting. Thank you.