Posted to microsoft.public.excel.programming

JM[_4_]

external usenet poster

Posts: 1

Calling Excel array functions in VBA

Is it possible to call an Excel array function in VBA?

For instance, in a worksheet, one can execute
{=SMALL(A1:10,{1,2,3})}

Can a similar call be made in a VBA module? If so, what
is the syntax and how is the result returned?

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
Calling functions from Excel worksheets and the Find function in XL '97	Mike-hime	Excel Programming	1	January 8th 04 03:17 AM
Calling functions from dll	T.K Kullervo	Excel Programming	0	September 29th 03 09:55 AM
Calling Add-in functions from VBA	Mark[_21_]	Excel Programming	5	September 12th 03 08:49 PM
Calling certain functions within VBA	james	Excel Programming	0	August 11th 03 10:27 PM
Calling VBA functions from a xll	Kim[_8_]	Excel Programming	2	August 3rd 03 11:48 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us