There's a bug in xl97 that can be resolved by changing the .takefocusonclick
property of the commandbutton to false.

Or you can add:

activecell.activate

at the top of the code.

It was fixed in xl2k.

Sean T. wrote:

O'boy,

After further testing the problem has become more convoluted. I closed and
reopened the file and was able to run the code posted above from the VBAIDE.
When I attempted to run the code via a "Command Button", the problem line
generated an error. Not only that but the line now generated an error back
in the IDE.

I repeated the Close/Open but could not get it to run in the IDE. I
substituted in Tom's code and got it to run once before it too started to
fail with the inclusion of a "Command Button".

Perhaps it would be easier to upgrade the old laptop with a more modern
Excel install.

I do appreciate the assistance,
Sean

--

Dave Peterson