Tnanks for the response Simon;

using this:
If bid < oldlo Then
oldlo = bid
End If
If ask oldhi Then
oldhi = ask
End If

and this:
ActiveCell.offset(0, reqOffset + 7).Value = oldhi
ActiveCell.offset(0, reqOffset + 8).Value = oldlo

gave the same results as the original does...


--
rnrss
------------------------------------------------------------------------
rnrss's Profile: http://www.excelforum.com/member.php...o&userid=27823
View this thread: http://www.excelforum.com/showthread...hreadid=474926