| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting Names from a workbook to a value in a Macro
I have a workbook with a name "boolPaintCells", which is a boolean and
refers to a cell in sheet 1. I want to have my macro change boolPaintCells value to FALSE (and thus the cell to false?), so I put in: Workbook.Names("boolPaintCells").Value = False It returns a run time error which, when debugged, stops at the above line of code. Any suggestions about what I am doing wrong? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Run macro to find names on seperate workbook, then add info from t | Excel Discussion (Misc queries) | |||
| Addin macro to delete names in current workbook | Excel Programming | |||
| Setting file names | Excel Programming | |||
| Macro to remove all names from workbook | Excel Programming | |||
| Sending email via macro- setting the importance setting. | Excel Programming | |||
Threaded Mode
