Here is another update:

tried this and here are the results:

cell p8 is <=edemo13|tik!id0?bid
cell p9 is <=edemo13|tik!id0?ask

in excel in cell 21 i entered <=p8 the cell for the bid and same wit
the ask where cell 22 <=q8

then I told vb to get the values and rewrite them into cells 23 and 2
respectively just to see if it would work and I get a type mismatc
error...

bid1 = ActiveCell.offset(0, 21).Value
ask1 = ActiveCell.offset(0, 22).Value
ActiveCell.offset(0, 23).Value = bid1
ActiveCell.offset(0, 24).Value = ask1

Everything I try doesnt work..

--
rnrs
-----------------------------------------------------------------------
rnrss's Profile: http://www.excelforum.com/member.php...fo&userid=2782
View this thread: http://www.excelforum.com/showthread.php?threadid=47492