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

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?

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

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

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

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