Amerifax-Bob Posted January 15, 2005 Report Share Posted January 15, 2005 I have 180 lines of code of which 7 line appear 15 times. In other words I have 7 contiguious lines of code that are in the macro 15 times. Is there a way to make a refference to just the 7 lines with a short one line code. I believe that the Macro Run, page 186, would do it. I just am not sure if a speed increase would happen. Bob Quote Link to comment Share on other sites More sharing options...
joe Posted January 16, 2005 Report Share Posted January 16, 2005 The Macro Run command is what you want. It works like a subroutine call. Just place those seven lines of code within a new macro and call it. It will not increase the speed the speed of your macro, but neither should you notice a decrease in speed either. Quote Link to comment Share on other sites More sharing options...
Amerifax-Bob Posted January 17, 2005 Author Report Share Posted January 17, 2005 >>It will not increase the speed the speed of your macro, but neither should you notice a decrease in speed either. << Good poi nt. Thanks Bob Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.