Posted to microsoft.public.excel.programming

Smallweed

external usenet poster

Posts: 133

Range or Array?

Does anyone know an easy way of telling whether the input argument of a UDF
is an Excel range, a VBA array or a variant? IsArray doesn't work because it
returns a True for all cases. 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
How to fix an array or range	delboy	Excel Discussion (Misc queries)	1	February 12th 08 08:14 PM
Range to Array	Gary''s Student	Excel Programming	5	June 7th 07 09:22 PM
copy one array formula to an array range	guedj54	Excel Programming	2	October 29th 06 07:38 PM
Tricky array formula issue - Using array formula on one cell, then autofilling down a range	aspenbordr	Excel Programming	0	July 27th 05 03:59 PM
Array <--- Range	Charley Kyd[_2_]	Excel Programming	7	January 14th 04 08:00 AM

All times are GMT +1. The time now is 11:30 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us