Deleting Cells

[brentjohn]

Greetings,
I am wanting to copy and paste a range (DC12:DC90) to another column range (DD12) and remove the blank cells. However, in the range (DC12:DC90) I am using a formula within those cells (=IF(CZ12=1,DE12,""). I have tried the following 2 macros but the range (DD12) still is showing the blank cells.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[brentjohn]

I just figured it out. I don't need the typical "copy/paste" coding.

Please Login or Register  to view this content.

[Richard Buttrey]

You can simplify those two macros into one

Please Login or Register  to view this content.