Hi,
My excel has thousands of rows and columns. Every time I give a search and replace, it becomes unresponsive and crashes.
So, I wish to run the search and replace only for 100 rows from the point of start. I am trying to find "#N/A N/A" with "#NT" .
How can I do this? Please help me.
Thanks!
Select the 100 rows and replace the #N/A with #NT and repeat the step for N/A too...
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Thanks Sixthsense, but I am looking for a script. I have 35 files with 70000 lines each. Manual selection is not practical in my case.
unless you are suggesting that i can record a macro doing so and loop that macro in OnTime. Hmmmm... I can give this a try...
Not sure what do you mean by OnTime
By OnTime, I meant the OnTime function. I will run it every 10 seconds just to give excel some breathing time.
This crude, but it should work resonably quickly. Try it on a backup workbook.
Please Login or Register to view this content.
Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
I am the real 'Napster'
The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...
If you receive help please give thanks. Click the * in the bottom left hand corner.
snb's VBA Help Files
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks