| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro-insert text(personal comment)
Hi, is there anyway i can insert personal text(ideas) in a macro?
Ex: .......Here begins date macro............. MACRO .......Here it ends.................. .......Here begins copy/paste macro...... MACRO .......Here it ends......... Can this be done? Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macro-insert text(personal comment)
Use a single quote before your comment
'Here begins date macro It will show in Green you must enter the single quote on each line of code that has a comment. "puiuluipui" wrote: Hi, is there anyway i can insert personal text(ideas) in a macro? Ex: ......Here begins date macro............. MACRO ......Here it ends.................. ......Here begins copy/paste macro...... MACRO ......Here it ends......... Can this be done? Thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macro-insert text(personal comment)
Works perfect!
Thanks! "Sean Timmons" wrote: Use a single quote before your comment 'Here begins date macro It will show in Green you must enter the single quote on each line of code that has a comment. "puiuluipui" wrote: Hi, is there anyway i can insert personal text(ideas) in a macro? Ex: ......Here begins date macro............. MACRO ......Here it ends.................. ......Here begins copy/paste macro...... MACRO ......Here it ends......... Can this be done? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro to insert a comment | Excel Worksheet Functions | |||
| Need a macro to insert text in a cell that already has text.Excel | Excel Discussion (Misc queries) | |||
| macro to insert row after specific text | Excel Discussion (Misc queries) | |||
| Personal macro workbook and personal.xls | Excel Discussion (Misc queries) | |||
| How do I insert a comment when the Insert:Comment menu is greyed? | Excel Discussion (Misc queries) | |||
Linear Mode
