| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOWTO Reference a named cell or range in a script
In a windows script I have the following statement to put a value
into a worksheet that I have opened in the script: objExcel.Cells(1, 1).Value = "y" If I assign a name to cell 1,1 in EXCEL -- say for example print_Y_or_N -- can I then refer to cell 1,1 (in the script) using that name? Sortof like you could in a VBA macro, like [print_Y_or_N] = "y" I think using a name instead of hard-coded cell cooridnate improves maintainability. Doesn't it? TIA, Phil |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
HOWTO Reference a named cell or range in a script
hi
yes. but the syntax would be more like this. Range("print_Y_or_N") = "Y" regards FSt1 "pwrichcreek" wrote: In a windows script I have the following statement to put a value into a worksheet that I have opened in the script: objExcel.Cells(1, 1).Value = "y" If I assign a name to cell 1,1 in EXCEL -- say for example print_Y_or_N -- can I then refer to cell 1,1 (in the script) using that name? Sortof like you could in a VBA macro, like [print_Y_or_N] = "y" I think using a name instead of hard-coded cell cooridnate improves maintainability. Doesn't it? TIA, Phil |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
HOWTO Reference a named cell or range in a script
Thanks for your reply FSt1.
objExcel.Range("automationFlag") = "Y" did the trick. Phil "FSt1" wrote: hi yes. but the syntax would be more like this. Range("print_Y_or_N") = "Y" regards FSt1 "pwrichcreek" wrote: In a windows script I have the following statement to put a value into a worksheet that I have opened in the script: objExcel.Cells(1, 1).Value = "y" If I assign a name to cell 1,1 in EXCEL -- say for example print_Y_or_N -- can I then refer to cell 1,1 (in the script) using that name? Sortof like you could in a VBA macro, like [print_Y_or_N] = "y" I think using a name instead of hard-coded cell cooridnate improves maintainability. Doesn't it? TIA, Phil |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying a named range with a changing cell reference | New Users to Excel | |||
| reference first cell in a named range | Excel Worksheet Functions | |||
| HOW TO EXTRACT CELL REFERENCE AS TEXT FROM NAMED RANGE | Excel Worksheet Functions | |||
| HowTo disable cell reference update | Charts and Charting in Excel | |||
| Named Range reference via single Cell | Excel Discussion (Misc queries) | |||
Linear Mode
