Posted to microsoft.public.excel.programming

Amish

external usenet poster

Posts: 19

Array in User Function

I'm trying to fill an array in a user-defined function and I get the
following error:
Compile error: Can't assign to array

I've tried to input the text as strings and using the address of the
same data in a worksheet and I get the same error. Is there a trick to
this or are arrays not allowed in functions?

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
Passing an array in a user defined function	Laurie	Excel Programming	2	June 29th 08 04:37 AM
Passing an array in a user defined function	Peter M	Excel Programming	5	June 27th 08 10:45 PM
Using user function (vba) with sqrt(array)-only first answer	Awill	Excel Programming	1	August 24th 07 01:54 PM
User Defined Array Function	Pflugs	Excel Programming	6	July 31st 07 07:46 PM
Creating a User Defined Array Function	Jeff Mason	Excel Programming	6	November 24th 04 07:43 PM

All times are GMT +1. The time now is 05:04 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us