View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rimcon Rimcon is offline
external usenet poster
 
Posts: 1
Default C++ instead of VB for excel macros

I'm running 50,000 scenarios in a VB macro that involves looping through a 90 x 90 array. It takes 3 hours to run -- after implementing the macro speed-up tips I've received. I'm thinking about learning C++ to build a faster addin. Any comments on whether this is worthwhile? Or how much I should be able to cut the run time?

--
GP