Josh,

Why not

current list:
part1
part2C
part3
part4

Bernie
MS Excel MVP


"dsi" wrote in message
oups.com...
the task break-down
- copy all primary "P" rows in currentlist from master list to a new
summary workbook

master list:
part# | primary flag
part1 | P
part1B |
part2 |
part2B |
part2C | P
part3 | P
part4 | P


current list:
part2
part4

the only part of the code that doesn't work is my old loop... (it also
causes some seemingly unrelated code to stop working ie.some MsgBoxes
before it in the code)

josh