Identify Cells with value of 0 and delete 0 cell and adjacent cell

Hello,

I am having trouble writing a macro that both identifies cells with a value of 0 within a range and then deletng that cell and the cell to the immediate left. Ideally this macro would clear both cells and move the rest of the data up one row.

Thank you!

Sam

Hi Sam.

You need a select special Macro.

I think that you want just those two cells deleted not the entire row.

BRB

Correct, I only want those two cells deleted so that the cells below them will move up. I need the data to be without blanks so that I can bring it over to another worksheet without causing system issues after the workbook is finalized.

Here is your code.

Enjoy.

Please Login or Register  to view this content.

The line

Please Login or Register  to view this content.

Is where you select your range, modify that to suit your requirement.

Thank you mehmetcik!