Deleting groups of continuous rows where col K = "x"

Max,
Well is was probably Joanne Dru's fault then. <g>
Norman's approach using Instr is probably what's needed.
My code only works if "X" is the only thing in the cell.
Regards,
Jim Cone
http://www.realezsites.com/bus/primitivesoftware


"Max" <demechanik@yahoo.com> wrote in message...
Hi guys,
I want to delete groups of 9 continuous rows from where a flag: "X" is found
in col K. Eg: if K10 contains: "X", delete entire rows 10-18, and if K100
contains: "X", delete entire rows 100-108, and so on. Thanks.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Jim, thanks for explaining the subtleties. It was the "case" of the letter
(the flag in col K). My keyboard (or my fingers, rather) weren't working
too well. When I tried it again with a true-blue upper case: "X" in col K,
your sub ran superb and beautiful, just like Joanne Dru in the movie <g>.
Thanks!
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Jim Cone" <jim.coneXXX@rcn.comXXX> wrote in message
news:eh9tO$JNGHA.420@tk2msftngp13.phx.gbl...
> Max,
> Well is was probably Joanne Dru's fault then. <g>
> Norman's approach using Instr is probably what's needed.
> My code only works if "X" is the only thing in the cell.
> Regards,
> Jim Cone
> http://www.realezsites.com/bus/primitivesoftware
>
>
> "Max" <demechanik@yahoo.com> wrote in message...
> Hi guys,
> I want to delete groups of 9 continuous rows from where a flag: "X" is
found
> in col K. Eg: if K10 contains: "X", delete entire rows 10-18, and if K100
> contains: "X", delete entire rows 100-108, and so on. Thanks.
> --
> Max
> Singapore
> http://savefile.com/projects/236895
> xdemechanik
> ---
>
>