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

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 N" where N can be a number from 1 to 4, I want to
delete the content 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