You were using activecell without changing the active cell.

--
Don Guillett
SalesAid Software

"davegb" wrote in message
ups.com...
Don,
Thanks for your reply. Your routines work very well. I still don't
understand why mine doesn't work at all. Why does the "For Next" loop
not change values. I thought if you entered those commands, it would at
least increment itself. Obviously, there's more to it than just having
a "For each" and a "Next". What makes a loop loop?