Hi, Ive asked this question else were but cant seem to resolve.
Difficult to explain so please bear with me. Im sending data into excel
f every 2 seconds. Its going into column H filling down the column.
This is no problem. Im then linking this data to metastock to chart the
data. The problem I having is, because I linking the whole colum to
metastock, it charts the data as, (lets say the first 20 cells are
fillid with 10) , 10,10 etc but when it gets to the empty cell it see 0
although theres no data in that cell yet. As soon as there is data it
charts that correctly. Because its seeing 0's for all the empty cells,
Icant get the scaling correct in metastock. So far what ive tried is in
the worsheet_change is to have a a macro that says if h21 0 then row
h1 delete. The problem I have here is that it deletes ok, but because
the rows have moved uo, the next bit of data goes into h22 and h21 is
left blanc so my macro never fires again. Is there away to manipilate
the dde link to resize itself without copying and repasting. Or would
this work with charts in excel or would i have the same problem. Sorry
if this is long winded.