View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tom[_2_] tom[_2_] is offline
external usenet poster
 
Posts: 9
Default Conditional delete (reposting).

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