Posted to microsoft.public.excel.programming

Jason Morin Jason Morin is offline

external usenet poster

Posts: 63

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Public Variables	Jerry McNabb	Excel Discussion (Misc queries)	0	February 24th 08 01:26 AM
Public Password	Excel 2003 - SPB	Excel Discussion (Misc queries)	2	May 23rd 07 11:08 PM
Public Function	Monty	Excel Discussion (Misc queries)	9	December 24th 04 06:35 PM
public sub	Bob	Excel Programming	3	December 10th 04 08:49 PM
Public Sub Help	No Name	Excel Programming	2	May 18th 04 11:09 PM

All times are GMT +1. The time now is 03:35 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us