View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default 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.