Thread
:
Conditional delete (reposting).
View Single Post
#
6
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett