Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
make my VBA program faster
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
make my VBA program faster
Read the good info on this site Neal
http://www.decisionmodels.com/optspeedd.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Neil" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I make reports faster in excel using ADO | Excel Discussion (Misc queries) | |||
Make Excel Work faster | New Users to Excel | |||
REQ: A utilities program that would allow me to make columns into row for headings? | Excel Discussion (Misc queries) | |||
Make excel run large spreadsheets faster | Excel Discussion (Misc queries) | |||
Can faster CPU+larger/faster RAM significantly speed up recalulati | Excel Discussion (Misc queries) |