Archive of Mr Excel Message Board

Back to Forms in Excel VBA archive index
Back to archive home

conditional format - delete row

Posted by Ren on December 27, 2001 12:54 PM

If there is a "0" in column V, delete the entire row.

Can someone please rewrite this in correct form?

Re: conditional format - delete row

Posted by Kevin Mac on December 27, 2001 1:04 PM

Ren,

Where are you from????

Re: conditional format - delete row

Posted by Ren on December 27, 2001 1:08 PM

WHY? Can you help me? : If there is a "0" in column V, delete the entire row.

Re: conditional format - delete row

Posted by Kevin Mac on December 27, 2001 1:15 PM

WHY? Can you help me? :

The easiest way I know of to do it is to record a Macro to do it for you. I personally do not know of a way to use Conditional formatting to delete rows if the condition is true. However, I was just curious if I know you or not.

Re: conditional format - delete row

Posted by Ren on December 27, 2001 1:37 PM

Grew up in Northern California
I went to college in San Diego
I live in Houston now.
Where are you from?

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.