View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Nick Hodge
 
Posts: n/a
Default possible? =if(That cell = "a certain word", delete row, go next)

Jim

No, functions can only return a value, you will need a macro if you want
automated actions

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Jim" wrote in message
...
Can Conditions include operative actions if true or false? such as:

If cell A7 = "Smith", delete row if yes, go to next cell if no ???