View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
kassie kassie is offline
external usenet poster
 
Posts: 515
Default Are objects slow in VBA?

Maybe if you post your code, someone will be able to assist? VBA is not slow
though
--
Hth

Kassie Kasselman
Change xxx to hotmail


"Charles" wrote:

Hello

I just have a general question: in your opinion, are objects in VBA
slower than using directly arrays and subs? I mean you necessarily
have a few more declarations to do, etc in the object. But that aside,
does the management of objects by VBA significantly reduces the speed
of execution of the code?

I have made a try, and I am a bit disappointed by the exec time. Could
be my fault, but just asking in case...

thanks!
Charles