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 |
Excel97 versus Excel95
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 |
All times are GMT +1. The time now is 03:51 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com