The following line of code works just fine in a Macro running under
Excel95 on my desktop machine. When I tried to run the same macro
under Excel97 on a friends laptop, it was highlighted as an error.
Specifically, it did not like the "Do While" command.

NDX = 1: Do While NDX < IDN: SendKeys "{down}": NDX = NDX + 1: Loop

Is the reason that this command will not work on my friend's Excel97
machine because there was an error or omission in the original version
of Excel97, or am I using a command that has since been prohibited?

Michael

It ran without error for me in xl97.
--
Regards,
Tom Ogilvy


buczacz wrote in message
...
The following line of code works just fine in a Macro running under
Excel95 on my desktop machine. When I tried to run the same macro
under Excel97 on a friends laptop, it was highlighted as an error.
Specifically, it did not like the "Do While" command.

NDX = 1: Do While NDX < IDN: SendKeys "{down}": NDX = NDX + 1: Loop

Is the reason that this command will not work on my friend's Excel97
machine because there was an error or omission in the original version
of Excel97, or am I using a command that has since been prohibited?

Michael