cheers guys, this worked great and now back to working properly. i
cleaned the code and its now working fine again
thanks again for all your help
cheers
stu
------------------------------------------------
~~ Message posted from
http://www.ExcelTip.com/
~~View and post usenet messages directly from
http://www.ExcelForum.com/
~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements