Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array Help
I currently am using excel to gather data from an
instrument that is used in the lab. I can paste the results from the instrument program into an excel sheet using the paste special link, and the instrument program will automatically update the sheet using a DDE. The problem is it keeps overwriting the same cell (where the pastespecial link is placed). The instrument program is writing the data out in an array, and every time I try to do anything to the array, it says you cant modify it. I would like to just grab the first line of the array, and move it to another worksheet. Then when the DDE updates, I would like to have the second worksheet move down a row and write the next piece of data. Can someone please help an inexperienced excel user out. Thanks in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array Help
Dim rng as Range, rng1 as Range
set rng = worksheets("Sheet2").cells(rows.count,1).End(xlup) (2) set rng1 = Worksheets("Sheet2").Range("A5:M5") rng.Resize(1,rng1.columns.count).Value= rng1.Value -- Regards, Tom Ogilvy "steve yuchs" wrote in message ... I currently am using excel to gather data from an instrument that is used in the lab. I can paste the results from the instrument program into an excel sheet using the paste special link, and the instrument program will automatically update the sheet using a DDE. The problem is it keeps overwriting the same cell (where the pastespecial link is placed). The instrument program is writing the data out in an array, and every time I try to do anything to the array, it says you cant modify it. I would like to just grab the first line of the array, and move it to another worksheet. Then when the DDE updates, I would like to have the second worksheet move down a row and write the next piece of data. Can someone please help an inexperienced excel user out. Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Complex conditional summing - array COUNT works, array SUM gives#VALUE | Excel Worksheet Functions | |||
Array formula: how to join 2 ranges together to form one array? | Excel Worksheet Functions | |||
Prevent cell/array references from changing when altering/moving thecell/array | Excel Discussion (Misc queries) | |||
meaning of : IF(Switch; Average(array A, array B); array A) | Excel Worksheet Functions | |||
combining cells and array from different sheets into an array to pass to IRR() | Excel Discussion (Misc queries) |