Clear entire rows if cell is blank

[jordanburch]

Hey All,

I am trying to create a macro to clear the rows if a cell is blank. It has to be dynamic because sometimes the cell will or wont be blank. If any cell in the range C8:c17 is blank i want it to clear that entire row. It can clear a range if that makes it faster or easier the range would be A8:J17. Any help would be greatly appreciated!

Thanks,

J

 

[Fluff]

Soemtimes, we overlook the obvious!

All too easily done unfortunately.

 

[Joe4]

All too easily done unfortunately.

Especially on a Monday morning!

 

[Fluff]

Maybe you need a few more