Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
remarking VBA code
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
split post code (zip code) out of cell that includes full address | Excel Discussion (Misc queries) | |||
remarking VBA code | Excel Programming | |||
Protect Sheet with code, but then code will not Paste error. How do i get around this. Please read for explainations.... | Excel Programming | |||
Modification in the CODE to HIDE rows and columns that start with ZERO (code given) | Excel Programming | |||
Excel code convert to Access code - Concat & eliminate duplicates | Excel Programming |