Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 176
Default 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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
start at a specific point G. Charts and Charting in Excel 1 October 29th 08 05:19 PM
How to prevent editing within a specific cells? Eric Excel Discussion (Misc queries) 1 October 24th 08 05:17 AM
Need macro to start at a new line MHenderson Excel Worksheet Functions 2 November 2nd 07 04:00 PM
Start Cells with Specific Value Beamers Excel Discussion (Misc queries) 1 March 28th 07 12:22 AM
How to start Excel on a specific Worksheet. JMay Excel Discussion (Misc queries) 6 February 21st 07 05:45 AM


All times are GMT +1. The time now is 04:28 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"