Excel 2007 replace

Jim WV · #3 07-17-2011, 01:44 AM

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?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel 2007 to Outlook 2007 - task import possible?	mjwillyone	Outlook	2	07-05-2023 07:23 AM
Excel 2007	IRoy	Excel	2	04-28-2011 02:26 AM
Help with find and replace or query and replace	shabbaranks	Excel	4	03-19-2011 08:38 AM
Excel 2007 to Word 2007 Labels mail merge not working	rec	Mail Merge	0	07-31-2010 10:45 AM
Example req for VBA app in excel 2007 (for Office 2007)	aligahk06	Excel	0	08-28-2009 04:36 AM