Delete range if column contains

[iVega]

Hi,

I am wondering how I can enter the following task in VBA: if cell
Px = 0, clear contents in Lx to Sx.

I tried doing this without VBA using a simple if-then statement, however, I need the contents of the cell to be absolutely cleared because the range will be imported into another worksheet where all blank rows will be deleted. And unless cleared, excel still recognizes something in the cells.

Thanks!

[JOHN H. DAVIS]

Maybe:

Something like this?

Please Login or Register  to view this content.

[Richard Buttrey]

Hi,

Please Login or Register  to view this content.

Modify the 'Sheet1' name as necessary

[iVega]

Richard, that looks like what I'm looking for, except when I use it in my macro I get the run time error 424, object required. Any idea? I have changed the sheet1 to the name of mine. Thank u.