i was "dim"ing it before i inserted the new worksheet - it doesn't
exist @ the beginning of the sub. i was under the impression you
"dim"med everything in the beginning regardless of where it pops in.
the userform is basically a msgbox that says "pls wait while the macro
is running." when i started this sub i was just learning userforms &
was practicing incorporating one. i can probably change this to a msg
box now.
it seems i'm on the right track now - i worked on this more late
yesterday & will today - do you mind looking @ it again when i *think*
i've got it done?
if not, that's ok (i see you're very busy answering posts! (& probably
have a job to do, too!)) - i greatly appreciate your help.
thanks
susan