View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jezebel[_3_] Jezebel[_3_] is offline
external usenet poster
 
Posts: 45
Default Visual Basic code inversion

Copy the lines of code and paste into a column in a worksheet.
Number the rows
Sort by the row number descending
Copy back to the macro


Seems an insane way to write macros, but whatever floats your boat.





"Zakynthos" wrote in message
...
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