Using the ' to exclude comments will fail only if you have made a mistake
somewhere in the placement of these comments.

Perhaps you inserted a comment after a line-continuation mark(_)

Post an example of code that fails.

You can always use Rem instead of the ' but can also fail for the same
reason as above.


Gord Dibben MS Excel MVP


On Wed, 22 Apr 2009 12:31:58 -0700 (PDT), jfcby wrote:

Per,

Thanks for the reply.

But, when running some macros they error out using ' to comment out
lines of code.

Is that the only way to comment code in vba?

jfcby