Sounds like a job for dynamic named ranges man... aka Ray Blake!!Check out his web site at http://www.grbps.com... and in particular http://www.grbps.com/articles.htmPlease get back to us if you still have problems.