Hello,
I have a macro that disables autocalc at the beginning to speed up the find/replace process for large quantities of data. The code works flawlessly but I cannot get autcalc to turn back on. I have it in the code and have stepped through the code with F8. It appears to be working but at the end when I run any mass calculations (e.g, dragging a calculation down, my autocalc is still set to off). Can you tell me what I am missing?
Please Login or Register to view this content.
Please Login or Register to view this content.
Other things to note:
1.) Remove or comment out the On Error line to see if your code throws an error. It's not good practice to just ignore code errors unless that's your explicit intent.
2.) In this case, the code doesn't go any faster because of
You are only using one Replace function then turning those Application settings back on. There's no advantage to turn them off and only do one thing. The advantage is to turn them off when doing a loop or using multiple functions; especially when repeatedly using ones that are slow.Please Login or Register to view this content.
3.) You use variable names like Find and Replace. Those happen to be identical names of functions as well. It's leagle to use those variable names, but its's considered unnecessarily confusing and bad practice.
Last edited by AlphaFrog; 08-24-2016 at 03:34 PM.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
How would I be able to go through the entire process and then turn on auto calculations within the same code?Originally Posted by AlphaFrog
Other things to note:
1.) Remove or comment out the On Error line to see if your code throws an error. It's not good practice to just ignore code errors unless that's your explicit intent.
2.) In this case, the code doesn't go any faster because of
You are only using one Replace function then turning those Application settings back on. There's no advantage to turn them off and only do one thing. The advantage is to turn them off when doing a loop or using multiple functions; especially when repeatedly using ones that are slow.Please Login or Register to view this content.
3.) You use variable names like Find and Replace. Those happen to be identical names of functions as well. It's leagle to use those variable names, but its's considered unnecessarily confusing and bad practice.
Please Login or Register to view this content.
Thank you Alpha Frog for teaching me. I appreciate you giving me some of your time and solutions.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks