Commenting out code
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. |
Commenting out code
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. |
Commenting out code
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. |
All times are GMT +1. The time now is 12:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com