Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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) |