Tom:
Took a Christmas break. Hope yours was a happy and merry one!

Anyway, thanks for the reply, but still not able to get the macro to work.
I am using Excell 2000. I made a macro and copied your instructions into the macro
as you sent them to me. Tried running the macro from the macro - run macro selection
and also from a macro button assigned to the macro.
Both ways produced no results at all. No copying of worksheet 1, a1:a3 to the the worksheet 2.

Not sure what I am doing wrong but I have appreciated all your help.

Mike