Thanks, its a find-replace operation after I select a big range of cells (e.g., 100 column x 1,000 row). It's like lightning in excel 2003, but I can actually observe how slowly it works in 2007. I believe it has something to do with formatting of cells. Noticed slowness in running a search-replace macro I wrote for 03, too.
I'm over my rant, sorry for the melodrama.
Regards
Jim
Quote:
Originally Posted by Colin Legg
Um.... welcome to the forum, Jim. 
I just did a find/replace empty cell / 0 without a problem in XL 2010. I've got XL 2007 kicking around so I can test on that version too but, before I do, can you give me a step by step breakdown of what you're doing and what's going wrong for you? |