View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Zakynthos Zakynthos is offline
external usenet poster
 
Posts: 115
Default Visual Basic code inversion

Bill,

Thanks, I've already come to the same conclusion and I'm on the case.

Regards,

Tony

"Bill Martin" wrote:

Zakynthos wrote:
Is there a piece of code I can input to a visual basic macro that will enable
it to execute in reverse order? In other words, if line 1 of the code was
Sendkeys "C1" and line 500 or whatever was Sendkeys "{TAB}", I would want it
to run from line 500 to line 1.

This will allow me to fix a small 'glitch' in which the first bloc of code
in a series of macros always runs in reverse order when run with other
macros, when run alone it runs correctly.

Many thanks


-----------------------

Sounds to me like you'd be further ahead to figure out what's causing your
bizzare glitch and fix the intrinsic problem -- rather than patching around it
like this.

Good luck...

Bill