View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] chris_culley@yahoo.com is offline
external usenet poster
 
Posts: 31
Default Speed up VBA - using class objects

Hi there,

I've read quite a few of the "How do I speed up my VBA" posts, and
they've contained a few useful tips that I'll be using... a more
specific question...

I'm working on a monte carlo simulator whose functionality is written
pretty much entirely in a single loooong method. I've knocked a couple
of hours of it's runngin time already, and am at the point of
clutching at straws to get rid of a few more minutes...

I heard from someone that splitting my code up and approaching it from
a more OO perspective, using excel user defined classes might speed it
up. Has anyone got an opinion on this?

Any other ideas, beyond disabling screen updating would be greatfully
recieved :)

Cheers

Chris