Find last row that contains data and clear/delete all blank rows after it

Is there a quick and efficient VBA code I could write to accomplish this? Everything I find online seems very complex.

What are you clearing if the rows are already blank?

I am cut and pasting a bunch of data and columns on a daily basis each morning. The amount of rows vary. The person who creates the source file I am copying has columns of formulas in the far right side of the sheet that go down to the 60K row range so that he doesn't have to copy/paste down the formulas each day. Therefore, there are blank rows that display nothing, but contain some formulas.

Originally Posted by tkbuc

The person who creates the source file I am copying has columns of formulas in the far right side of the sheet that go down to the 60K row range so that he doesn't have to copy/paste down the formulas each day.

If that is the only column like that, which column is it?

Do you have formulas in any other columns?

Please Login or Register  to view this content.

If the data you are keeping does not have formulas you can also use SpecialCells.

Please Login or Register  to view this content.

The following macro will clear all rows that are either blank or have a formula displaying the empty text string ("") that are located after the last displayed non-blank value (whether it is a constant or from a formula)...

Please Login or Register  to view this content.