Best book to learn VBA applied to Arrays and Functions?

[actjfc]

Hi everybody,

I would like to master building Functions that use AND RETURN arrays. The code samples that I have found in the WWW and many books are usually quite simple and do not meet my expectations as samples.

I would like to hear from power users that have managed quite complicate functions using arrays as input and output, so What is the best book to learn it well?

I do know that Mr Excel sells some very interesting titles, but I do not know if he really develops these topics in depth. Can somebody talk about it?

I also welcome some suggestions of WWW sites where to find no so simple VBA Arrays code samples.

Thanks!

 

[xld]

John Walkenbach's Excel 2003 Formulas ISBN: 0764540734 perhaps.

 

[NateO]

Well, as I was mentioning in our other discussion, Excel is array-hungry software in both the back and front end.

Alan Beban has some array stuff here:
http://home.pacbell.net/beban/

This HOF entry certainly deals with arrays in Worksheet Functions:
http://www.mrexcel.com/wwwboard/messages/8961.html

Tracy Syrstad's & Bill Jelen's book has a chapter on programmatic arrays (in VBA):
http://www.mrexcel.com/vbabook.html

Most of these sights probably use an array at one point or another:
http://www.mrexcel.com/board2/viewtopic.php?t=131224

And, the VB2theMax Archive has some awesome VB array examples:
http://www.devx.com/vb2themax/?cat=1159

Some of them are .Net examples so be careful what you're looking at.

And, I'd say play with them, google on them, and post questions here on them.



Edit: Fixed egregious error!

 

[actjfc]

Thanks for the suggestions. I will certainly review them. Only one more question: I Have read some articles that mention the .NET matter, but I have not have the time to search more about it.

Can you tell in a pill what does ".Net" mean for a VBA software developer/programmer?

Thanks!

 

[NateO]

You're welcome.

Haven't read J-Walk's book, could be good...

Re: .Net; see the following:
http://www.dicks-blog.com/archives/2005/03/09/support-classic-vb/