ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   VBE-Neutralizing a set of lines from eunning (https://www.excelbanter.com/excel-programming/386581-vbe-neutralizing-set-lines-eunning.html)

avi

VBE-Neutralizing a set of lines from eunning
 
Hello,

How do i neutralize a group of successive lines from running , besides
putting a quote (') before each line?

Thanks
Avi


John Bundy

VBE-Neutralizing a set of lines from eunning
 
Kind of weird request, but I suppose you can put something like x=1 and then
have before the code to stop if x=1 then (your code). then you just change x
to 0 when you want to stop it.
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"avi" wrote:

Hello,

How do i neutralize a group of successive lines from running , besides
putting a quote (') before each line?

Thanks
Avi



jaf

VBE-Neutralizing a set of lines from eunning
 
Hi Avi,
If you have the edit toolbar turned on, select the lines with the mouse and
click the "Comment Block" button.


--
John
johnf202 at hot mail dot com


"avi" wrote in message
oups.com...
Hello,

How do i neutralize a group of successive lines from running , besides
putting a quote (') before each line?

Thanks
Avi




avi

VBE-Neutralizing a set of lines from eunning
 
Great! Thanks a lot!

Avi


Chip Pearson

VBE-Neutralizing a set of lines from eunning
 
You could use conditional compilation. E.g.,

#If FALSE Then
< code not to run
#End If




"avi" wrote in message
oups.com...
Hello,

How do i neutralize a group of successive lines from running , besides
putting a quote (') before each line?

Thanks
Avi





All times are GMT +1. The time now is 12:13 PM.

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