Posted to microsoft.public.excel.programming

Jesse[_7_] Jesse[_7_] is offline

external usenet poster

Posts: 13

Custom function, sheet vs array

I have a custom function that creates a distribution based on locations
and pulls from a large reference sheet of data.

The data sheet 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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to 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
Custom Function in Array Formula	RincewindWIZZ[_2_]	Excel Programming	1	May 26th 05 04:42 PM
Custom Function in Array Formula	RincewindWIZZ	Excel Programming	1	May 25th 05 06:20 PM
Passing an array as argument for custom Function	No Name	Excel Programming	4	March 7th 05 04:44 PM
Preformatted array returned by custom function	Asif[_3_]	Excel Programming	9	December 4th 03 06:31 AM
returning an array from a custom function	Ron Davis	Excel Programming	2	September 15th 03 11:02 AM

All times are GMT +1. The time now is 05:56 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us