I'm trying to write a code to update a cell value based on its current text and the beginning character of the adjacent cell. I've written the below code, but the sheet is roughly 77,000 lines, and it is taking forever to run (the attached is about 40k lines).
Can someone help me update/ simplify this so that it runs smoothly and quickly?
Please Login or Register to view this content.
The first thing you could try is not activating/selecting.
If that doesn't speed things up sufficiently you could try using an array.Please Login or Register to view this content.
Please Login or Register to view this content.
If posting code please use code tags, see here.
Try:
Please Login or Register to view this content.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
Another optionAlthough this will convert the numbers to proper numbers rather than textPlease Login or Register to view this content.
Thank you all.
Norie and Mumps1,
The array solutions work great! However, I've hit a snag.
In my actual spreadsheet, the data are in D:E, not A:B. I was thinking I could take the code and change the cell reference, but that's not working.
I'm guessing it has something to do with the bounded variables, but I am unsure.
Try:
Please Login or Register to view this content.
Try this.
Please Login or Register to view this content.
Norie and Mumps1,
Again, thank you both! Both solutions get me what I want.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks