Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
refer to cells by number
Hi,
I'm a newbie to excel automation and could do with some guidance. I'm trying to set cell values using variables within office 2007 but the only method I can find to set values is via "Range" - and I can only appear to specify Range values if a column header is specified: eq. A2. I don't seem to be able to reference "Cells", "Row" or "Column" directly For example, I am currently having to use: ExcelWorksheetobject.range("A1").value2 = "my value" Any guidance would be appreciated. Thanks Neil |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to find cells that refer to data in other cells in excel | Excel Discussion (Misc queries) | |||
Worksheet function to refer to columns by number | Excel Discussion (Misc queries) | |||
Using cells to refer to worksheets | Excel Worksheet Functions | |||
refer to worksheet by index number in formula | Excel Programming | |||
How do I refer to a freeform name and number on a chart using VBA | Excel Programming |