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.

No comments:

Post a Comment