Hi,

I know how to comment out code line by line

Is there a way to comment out multiple lines at once.

Like in C++ you can
use - "/*"
and - "*/"

Is there something in excel because I have a lot of code that has to be
commented out and I dont want to go line by line and click " ' ".

Thanks for your help.

Hi Jeff

In the VBA editor right click on the menu bar and check Edit.
On this toolbar there are two buttons that you can use for the selected code

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Jeff" wrote in message ...
Hi,

I know how to comment out code line by line

Is there a way to comment out multiple lines at once.

Like in C++ you can
use - "/*"
and - "*/"

Is there something in excel because I have a lot of code that has to be
commented out and I dont want to go line by line and click " ' ".

Thanks for your help.

Jeff

In VBE Right-click on a toolbar then CustomizeCommandsEdit.

Drag Comment Block and UnComment Block buttons to your Toolbar.


Gord Dibben MS Excel MVP

On Wed, 31 Jan 2007 09:58:02 -0800, Jeff wrote:

Hi,

I know how to comment out code line by line

Is there a way to comment out multiple lines at once.

Like in C++ you can
use - "/*"
and - "*/"

Is there something in excel because I have a lot of code that has to be
commented out and I dont want to go line by line and click " ' ".

Thanks for your help.