Thank you for your response. Your code worked fine as long as there were
no values in ay1 or az1 but as soon as values were enytered and the
macro was run I got a "Run-time error '1004': Method'Range'of
Object'_Global'Failed" error message. Any suggestions? Thanks -- Ray



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!