Thread: VBA Question: IF value in M 0, set O="Delete"
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Wigi Wigi is offline
external usenet poster
  
Posts: 396
Default VBA Question: IF value in M 0, set O="Delete"
Hi

You could use an Autofilter, to filter out the strictly positive values in
column M.

Then go to column O, select the whole column, hit F5 Special... visible
cells, hit Delete.


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"porter444" wrote:

In my worksheet I have several rows that I want to delete based on a flag
value from other calculations. What I need to do is set the value in column
O to "delete", for the corresponding row, IF the value in column M is 0.

Logic is like this:

IF M 0, then set O="Delete"

Can you help?

Thanks in advance!

Scott
Reply With QuoteReply With Quote