Custom function, *** vs array
- From: "Jesse" <jesseh77@xxxxxxxxx>
- Date: 4 Aug 2006 13:31:11 -0700
I have a custom function that creates a distribution based on locations
and pulls from a large reference *** of data.
The data *** has 30,000 cells approx and currently I run a look
through the 120 locations to build a distribution based on criteria
specified. Sheets that use this function normally have about 250
references to this function.
Would the performance gains from using an array be worth the effort of
converting the function?
Jesse
.
- Prev by Date: RE: VBA Click Command Button
- Next by Date: RE: Maintaining Maximum Platform Compatibility
- Previous by thread: Mass amounts of buttons
- Next by thread: check box and Wacom
- Index(es):