Thanks for the help, that appears to have worked, except now I get
popup that asks what DDE link to use, and it gives me some pre-existin
links that I have created using my DDE client (RSLinx).

This is probably a long shot, but does anyone know how to not have thi
pop up and just use the exact text that is shown in the given cell

--
pete358
-----------------------------------------------------------------------
pete3589's Profile: http://www.excelforum.com/member.php...fo&userid=2840
View this thread: http://www.excelforum.com/showthread.php?threadid=57416