View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lost in Alabama Lost in Alabama is offline
external usenet poster
 
Posts: 26
Default macro to find data and select from active cell to the last row

I need help creating a macro to find "ZZZZZCount" in column J, then select
the Rows from the cell just found to the end of the sheet (R65000) and
delete. The cell location of "ZZZZZCount" will not be constant.

Thanks,


F G H J
Task Code Task ID Sub No. STSLN
JGDAAAA REPAIR AVENGER COMPOSITE PANEL 320 CHAA
JGDAAAA REPAIR AVENGER COMPOSITE PANEL 320 CHAA
JGDAAAA REPAIR AVENGER COMPOSITE PANEL 320 CHAA
JGDAAAA REPAIR AVENGER COMPOSITE PANEL 320 CHAA
JGDAAAA REPAIR AVENGER COMPOSITE PANEL 320 CHAA
JGDAAAA REPAIR AVENGER COMPOSITE PANEL 320 CHAA
JGDAAAA REPAIR AVENGER COMPOSITE PANEL 330 CIAA
100 ZZZZZCount
100 ZZZZZCount
100 ZZZZZCount
100 ZZZZZCount