Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am working with real time data and came across a problem where if
you the data is changing and you are trying to operate on the data, you will get an automation problem. My solution, is to snapshot the data, set it off to the side and then insert that data into a database. This seems to work because a selection of range stops RTD feeds. I'm trying to get the fastest throughput possible. Would it be better to operate on an in-memory array and then insert into the database or copy/paste values to another set of cells and then operate on the data? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Naming cell ranges, copying formulas for a range & nesting "IF" fu | Excel Discussion (Misc queries) | |||
Copying ranges | Excel Programming | |||
Copying into ranges | Excel Worksheet Functions | |||
copying ranges etc | Excel Programming | |||
Copying ranges | Excel Programming |