Paul,

Thank you! This macro works great. However, I have a another question
for you. How do I modify this macro if I want to display the contents
of all cells? I want to keep the output format of the macro (i.e. same
three columns in a new worksheet) but I want the macro to display the
contents of all cells, not just cells with formulas. I will attempt to
figure this out in the meantime but please let me know if you have any
suggestions. Thanks again!

Teresa


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