Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
I have an interesting problem. I am populating an Excel template from an Access database using ..Range(.Cells(8, 9), .Cells(8, 10)).select ..Range(.Cells(8, 9), .Cells(8, 10)).CopyFromRecordset rs All appears to work fine. When I open the Excel sheet, it doesn't seem like any of the data has been populated. BUT if I go to my immediate window, then cells(8,9) shows me the value that should have been pasted in, but range("L9") shows me the old value that should have been overwritten I was under the impression that Cells and Range were a synonymous way of refering to the same thing??? Any help would be appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Summing a range of cells based on criteria in another range | Excel Worksheet Functions | |||
When entering data into a range of cells, select the entire range. | Excel Discussion (Misc queries) | |||
how to compute a range of cells based on another range of cells? | Excel Worksheet Functions | |||
how to compute a range of cells based on another range of cells? | Excel Worksheet Functions | |||
Count cells in one range based on parameters in another range | Excel Worksheet Functions |