Forum Discussion
9 quick tips to improve your VBA macro performance
As part of our work to help enterprises upgrade to Office 365 ProPlus, we have found that some users have been experiencing slow running VBA, which can be frustrating. The good news is that there are...
Mark,
re: use of With statement
Ken Getz (author of the VBA Developers Handbook - many years ago) pointed out, that when using the With statement, you must reduce the number of dots used in order to improve efficiency.
Otherwise you are just saving typing time.
'---
Jim Cone
https://goo.gl/IUQUN2