Posted to microsoft.public.excel.programming

No Name

Posts: n/a

Passing an array as argument for custom Function

I am trying to find out how to pass an array as an
argument for a custom function.
I have an array colors(1 to 10) and I want to pass the
whole array into a custom fundtion so I can use the array
within the function.

Thanks.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode 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
Need help passing an array as an argument	blc[_3_]	Excel Programming	3	August 4th 04 10:35 PM
Passing range as an argument in a function	Hari[_3_]	Excel Programming	1	June 15th 04 02:41 AM
VBA - Passing a FUNCTION as an Argument	James B	Excel Programming	3	February 18th 04 03:42 PM
Passing an Array of User-Defined Type to an Argument of a Function	Tushar Mehta[_6_]	Excel Programming	0	August 17th 03 06:43 PM
passing a variable as an argument to a function	Drew[_6_]	Excel Programming	3	July 25th 03 08:51 PM

All times are GMT +1. The time now is 01:22 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us