make my VBA program faster
Hi
without posting the relevant part of your code this is difficult to
say. Some ideas:
- disable screenupdating
- disable automatic calculation
while running the macro
--
Regards
Frank Kabel
Frankfurt, Germany
Neil wrote:
I have a vba program that works with an excel file. It
used to be really slow b/c the vba program accessed data
in the excel sheet cell by cell. I greatly improved the
speed by using arrays when inputing into and out of the
sheet. I want to make the vba program faster. How can I do
this.
Thank you.
|