Thread: Dim vs. Public
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jason Morin Jason Morin is offline
external usenet poster
 
Posts: 63
Default Dim vs. Public

Hello and TIA for your help. I have a master macro that
runs several other macros, all in the same module.
Overall, I have maybe 30 variables across the macros, and
about 10 of them I set as Public. It would be easier to
declare all of them as Public, but I'm wondering what
effects (if any) this may have on speed. Using XL2003 on
WinXP.
Jason