Remove Blank Rows from all Sheets Macro Help!

Hi all,

First of all hello, I'm new to this forum and just about as new to VBAs and Macros! I'm hoping I can get some advice...

I have a workbook which contains 48 sheets. these 48 sheets have 2 lists of data varying length, that formulate from a master workbook. Each week the length of the lists change depending on the info input into the master. I then have a macro that saves each of these sheets into individual pdfs.

I have a code that works like a dream to remove all the blank rows on my first sheet- what I would love is if this could run through all of the 48 sheets, not just the first!

How do I add to my code "all sheets" rather than just the sheet in on?

I've spent the last 2 days Googling but I'm hitting a wall!


For info, the first list starts at C7 and is 9 columns long. I give about 100 rows to both lists just in case (the second starts beneath the first at about C107) and the "blanks" have forumla in but appear blank, my below code doesn't seem to mind this

My code is:

Please Login or Register  to view this content.

I've attached an example workbook that has the same layout as what I'm after!

Any help here?
TIA legends!

I have added code tags for you, as you are new. Please review the forum guidelines.

Try

Please Login or Register  to view this content.

Post a sample workbook.

It removes any rows where column C cell is blank: not what you want?

I don't know if this is the case in your workbook but a common problem is that cells look to be empty but have a non printable character in it (space is one of the possibilities)

If you run this on each sheet it should show which ranges are empty.

Please Login or Register  to view this content.

Or you can run this to see how many cells in that Range are not empty.

Please Login or Register  to view this content.