Excel Worksheets containing 1048576 rows -

[Danny54]

Is there a vba macro that will delete all empty rows of a worksheet?

I'm seeing my workbook sizes growing exponentially but when looking at the rows/columns that contain data, it showing the last row 2500, last column G.
I wouldn't think that the workbook size should contain 1048576 rows and have a filesize of 2641 kb.

Suggestions would be most appreciated.

 

[Joe4]

If you open any blank Excel workbook, it will show all rows, down to row 1048576, but that does not mean that is how many rows are used or saved, taking up that much memory.
Now, if you populate or pre-format all those rows, it may use them all. But it won't, by default, unless you explicitly do something to trigger it to.
So you shouldn't concern yourself because you can see a bunch of blank rows, unless you think Excel thinks that range is being used for some reason (because of something you did).

If you provide a bit more information on how you are using and populating this file, it may shed some light as to what is going on.

 

[Danny54]

that make since, is there a way to check for content, formulas, hidden stuff, ect.. - say the first 20 rows after the data isn't being displayed anymore

 

[Danny54]

oh, btw, when opening this workbook it takes serveral minutes.

 

[MARK858]

If you click cell A1 then do a Ctrl + End where does the cursor go to?

 

[Danny54]

Row 1239 row Q - this is what i expect. So, my takeaway is - file size and load time due to data residing in each used cell and row.

Thanks so much.

Have a wonderful day

 

[MARK858]

You're welcome

 

[Joe4]

Is there VBA code in the file, or links to other file/sources?
Those are also things that can slow files down.