View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected][_2_] thesquirrel@gmail.com[_2_] is offline
external usenet poster
 
Posts: 39
Default remarking VBA code

I have seen cases where if I try and create my sub with only remarks
(no code) and compile it, the remarks and sub disappear. With that
there is no saving involved, but would be an instance of remarks not
sticking.

theSquirrel


Chip Pearson wrote:
I've never heard of saving causing any changes to the VBA code. The REM
method of commenting code is a blast from the past of original BASIC.

I would use the ' character to comment your code.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)


"childofthe1980s" wrote in
message ...
Hello:

I'm trying to remark (REM) lines in VBA code.

But, when I try to do this and hit save, the spreadsheet's VBA code is not
saving the remarking.

Isn't it just a matter of putting an apostrophe in front of the code so
that
the lines in the code turn green? Or, am I doing it wrong?

Thanks!

childofthe1980s