How to make function which returns array?

Wrox Programmer Forums

		Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
How to make function which returns array?

Excel VBA Discuss using VBA for Excel programming.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

Old

April 10th, 2009, 04:49 AM

sektor

sektor is offline

Authorized User

Join Date: Mar 2008

Posts: 74

Thanks: 2

Thanked 0 Times in 0 Posts

Send a message via ICQ to sektor

Default

How to make function which returns array?

I wanna create a function which would return array. How to do it?

Old

April 11th, 2009, 01:05 PM

stanleydgromjr stanleydgromjr is offline

stanleydgromjr is offline

Authorized User

Join Date: Nov 2007

Posts: 48

Thanks: 0

Thanked 4 Times in 4 Posts

Default

sektor,

Hope this helps - see:
Returning Arrays From VBA User Defined FunctionsReturning Arrays From VBA User Defined Functions
http://www.cpearson.com/excel/Return...ysFromVBA.aspx

Have a great day,
Stan

__________________
stanleydgromjr

Windows 8.1, Excel 2007.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
function returns Incorrect syntax	keyvanjan	ASP.NET 2.0 Professional	1	July 29th, 2007 10:36 AM
how do i make a boolean array. helppp	Un33k	Visual Basic 2005 Basics	2	June 14th, 2007 06:56 AM
Count Function returns strange value	tslag	XSLT	2	June 23rd, 2006 10:13 AM
how can i make this function	justinho106	Access VBA	3	March 28th, 2006 01:07 PM
Problem with setTimeout and function returns	greg.webb	Javascript How-To	5	August 31st, 2005 02:00 AM