View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
buczacz buczacz is offline
external usenet poster
 
Posts: 19
Default Excel97 versus Excel95

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