Quote Originally Posted by scottiex View Post
I guess you have a formula resulting in an error in one of the cells.
For example a #N/A.
@scottiex...

Thank you, you wonderful, wonderful excel person you! lol

2 "#VALUE"'s in 9,000 rows...

deleted them and it worked fine.

@xladept: Thank you for the instructions. I was wondering how to do that...