Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Commenting out Rows in VB
If im not wrong there is a way to comment out a selection in VB with some key storke. what is that keystorke? -- MC82 ------------------------------------------------------------------------ MC82's Profile: http://www.excelforum.com/member.php...o&userid=18682 View this thread: http://www.excelforum.com/showthread...hreadid=503505 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Commenting out Rows in VB
Ordinary old apostrophe does the trick
Sub text() ' this line will not be executed this line will be executed End Sub Gord Dibben MS Excel MVP On Fri, 20 Jan 2006 15:07:41 -0600, MC82 wrote: If im not wrong there is a way to comment out a selection in VB with some key storke. what is that keystorke? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Commenting out Rows in VB
Anything after an apostrophe on a line is considered a comment.
For instance: ' This is a comment A = B ' Comment starts here |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Commenting out Rows in VB
I thought there was a key stroke to comment out selected code. Ie. If I highlight rows 1-5, then press some keystroke. Rows 1-5 will automatically have a ' infront of it. I guess I might be wrong, but I could have sworn I saw a ex-coworker do it. -- MC82 ------------------------------------------------------------------------ MC82's Profile: http://www.excelforum.com/member.php...o&userid=18682 View this thread: http://www.excelforum.com/showthread...hreadid=503505 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Commenting out Rows in VB
There is a button in the Edit toolbar (which of course you can include in
your standard toolbar) that does just that -- Kind regards, Niek Otten "MC82" wrote in message ... I thought there was a key stroke to comment out selected code. Ie. If I highlight rows 1-5, then press some keystroke. Rows 1-5 will automatically have a ' infront of it. I guess I might be wrong, but I could have sworn I saw a ex-coworker do it. -- MC82 ------------------------------------------------------------------------ MC82's Profile: http://www.excelforum.com/member.php...o&userid=18682 View this thread: http://www.excelforum.com/showthread...hreadid=503505 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Commenting out Rows in VB
Thanks thats exactly what I was looking for, just wished I could find out the keystroke, but that works for now. Thanks a bunch -- MC82 ------------------------------------------------------------------------ MC82's Profile: http://www.excelforum.com/member.php...o&userid=18682 View this thread: http://www.excelforum.com/showthread...hreadid=503505 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rows & Columns in Excel | Excel Worksheet Functions | |||
Automatically inserting rows | Excel Worksheet Functions | |||
Hiding Rows if the linked rows are blank | Excel Discussion (Misc queries) | |||
Insert rows | Excel Worksheet Functions | |||
flexible paste rows function that inserts the right number of rows | Excel Discussion (Misc queries) |