View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JulieD JulieD is offline
external usenet poster
 
Posts: 618
Default Shortcut way for indicating comments in block of code.

Hi Hari

not sure if this is the easiest way but on the EDIT toolbar in VBA is an
icon to add the comment ' and one to remove it ... so select the block of
code, click on the add comment block icon (i always click 3 times to
distiguish between this & normal comments) and then when you want it to run
again, select it and click on the remove comment icon the appropriate number
of times.

Cheers
JulieD


"Hari" wrote in message
...
Hi,

Sometimes I dont want to execute a long piece of code, lets say 15 to 20
lines of code in one block but I would like to execute rest of the code.

I will have to enter the comment indicator at the beginning of each of

those
lines. Rather than doing that is there a shortcut way for treating only

that
particular block of code as comment?

Regards,
Hari
India