yep now its been attached i can confirm i see #num! errors in 97 ,and i know you cant use whole ranges in excel 97, but perhaps if you had told us you 'were using named ranges from the beginning!