Don't use error handlers until yo know the code is working, they will
suppress error messages that would help.
Are you sure that the code is in the correct place, i.e. the workbook
module & not a Standard Module?
--
royUK
Hope that helps, RoyUK
For tips & examples visit my 'web site' (
http://www.excel-it.com/)
------------------------------------------------------------------------
royUK's Profile:
http://www.thecodecage.com/forumz/member.php?userid=15
View this thread:
http://www.thecodecage.com/forumz/sh...ad.php?t=75228