| 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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Setting Names from a workbook to a value in a Macro
Range("boolPaintCells").Value=False
HTH -- AP a écrit dans le message de news: ... 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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Setting Names from a workbook to a value in a Macro
Worked like a charm. Thanks.
-Abe Ardus Petus wrote: Range("boolPaintCells").Value=False HTH -- AP a écrit dans le message de news: ... 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? |
| Reply |
| 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 | |||
Linear Mode
