Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 270
Default Commenting out

Is there a way to comment out a whole procedure without placing apostrophes
at the beginning of all lines?

Thanks
Sandy

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,420
Default Commenting out

Add apostrophe to the first and add line continuation to all the lines.

--
__________________________________
HTH

Bob

"Sandy" wrote in message
...
Is there a way to comment out a whole procedure without placing
apostrophes at the beginning of all lines?

Thanks
Sandy



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,501
Default Commenting out

Use exit sub

Sub MySub()
Exit Sub
'Lots of code
End Sub

Mike

"Sandy" wrote:

Is there a way to comment out a whole procedure without placing apostrophes
at the beginning of all lines?

Thanks
Sandy

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 18
Default Commenting out

Hi Sandy,
try this one:
http://www.ozgrid.com/forum/showthread.php?t=10432

"Sandy" wrote:

Is there a way to comment out a whole procedure without placing apostrophes
at the beginning of all lines?

Thanks
Sandy

  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 270
Default Commenting out

Very easy too.
Thanks Franz

"Franz Erhart" wrote in message
...
Hi Sandy,
try this one:
http://www.ozgrid.com/forum/showthread.php?t=10432

"Sandy" wrote:

Is there a way to comment out a whole procedure without placing
apostrophes
at the beginning of all lines?

Thanks
Sandy



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
Commenting out code Jeff Excel Discussion (Misc queries) 2 January 31st 07 07:18 PM
Commenting out Rows in VB MC82 Excel Discussion (Misc queries) 5 January 20th 06 11:36 PM
Better Excel commenting SteveT Excel Discussion (Misc queries) 1 August 16th 05 02:55 PM
Conditional Commenting M H Excel Programming 2 July 22nd 05 11:42 AM
Commenting in Code Paul Black Excel Programming 7 October 9th 04 08:18 PM


All times are GMT +1. The time now is 03:35 AM.

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

About Us

"It's about Microsoft Excel"