ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Start a macro from a specific line while editing (https://www.excelbanter.com/excel-programming/278979-re-start-macro-specific-line-while-editing.html)

Bernie Deitrick[_2_]

Start a macro from a specific line while editing
 
Tolga,

Two ways:

First way: Select all the lines above, and click the "comment block"
button on the editing toolbar in the VBEditor.

To undo, just select the same block and click the "uncomment block"
button.

Second way: wrap your lines in a conditional, and set your boolean
value appropriately.

Dim Skip As Boolean
Skip = True

If Skip Then
.....Old code to skip here
End if

HTH,
Bernie


"Tolga & Hande" wrote in message
...
We want to start a macro from a specific line while
testing instead of from the first code to speed up
editing and testing.





All times are GMT +1. The time now is 08:29 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com