View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
pwrichcreek pwrichcreek is offline
external usenet poster
 
Posts: 34
Default 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