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.
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.