View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Conditional delete (reposting).

Show an ACTUAL sample

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"tom" wrote in message
...
Hi,

A B C
D E F
G H I

are a block of cells. Cell C is the active cell (cursor position). If cell
D contains the word "Group" e.g. "Group 3 and below", or "Group 4 and
above", I want to delete the contents of cells D, E, F, G, H and I. If
not, to continue on with the next line of code. Any help is much
appreciated.

TIA
Tom