sorry tom was surpose to be sheet("3") not lcis. Anyway it works a
treat. so in that case if I am coding on the Sheet then I must not use
terms such as sheets("1").select or . activate?
--
funkymonkUK
------------------------------------------------------------------------
funkymonkUK's Profile:
http://www.excelforum.com/member.php...o&userid=18135
View this thread:
http://www.excelforum.com/showthread...hreadid=542818