Болшое обновление на сайте Пирсона
http://www.cpearson.com/excel/MainPage.aspx
Рекомендую.
Далее осенние новости:
String Concatenation For Arrays And Ranges(20-October-2007)
The built in CONCATENATE function is severely limited in how it can be used. You cannot concatenate arrays or text in a range of cells, and it doesn't work in array formulas. This pages introduces a function named StringConcat that overcomes all the deficiencies of CONCATENATE.
Creating An XLA Add-In (8-October-2007)
This page is a complete rewrite desribing how to create XLA Add-Ins with VBA. If you know how to code in VBA, you know pretty much all you need to know about creating an Add-In. This page covers some details you might overlook.
Random Elements From A Worksheet Array (4-October-2007)
A new function has been added to the Random Numbers page that will return a specified number of elements from a worksheet range in random order without duplication.
Optional Parameters To A Function With ParamArray (29-September-2007)
This page describes how to use Optional parameters to a VB function and how to user ParamArray to accept any number of parameters, which may vary at run time.
Creating An Automation Add In Function Library In VB NET (25-September-2007)
This page describes how to create an Automation Add-In Function Library in VB NET.
Sorting And Ordering Worsksheets In A Workbook (22-September-2007)
This page contains VBA functions that can sort or otherwise order worksheets in a workbook. This is a complete rewrite of the original SortWS page with more code functions and features.
Splitting A String To SubStrings With Multiple Delimiters (21-September-2007)
This page contains VB/VBA functions for splitting strings into sub strings based on multiple delimiters. The delimiters many be single characters or strings of character.
Passing Parameters By Reference (ByRef) Or By Value (ByVal) (21-September-2007)
This pages describes the differences between passing a parameter, either or simple variable or an object type variable by reference (ByRef) or by value (ByVal).
Creating A TreeView Control For Folders And Files (15-September-2007)
This page desribes code to create a TreeView control to list subfolders and files of a folder. The techniques described on the page are not limited to creating a TreeView for folders and files. The code can be adapted to display any sort of data in a TreeView control.
Recursive Programming (14-September-2007)
Recursive programming is a powerful technique that can simplify otherwise complicated programming tasks. In summary, recursive programming is when a procedure calls itself passing to itself a modified value of the original input parameter(s). This pages uses the mathematical function Factorial to illustrate recursive programming techniques.
Matrix To Vector Formulas (13-September-2007)
It is often useful to convert a matrix (an worksheet range with at least two rows and at least two columns) to a single dimensional vector (a single row or single column) or to extract one row or column from the matrix. This page contains formulas to do this and an example using the formula to create a dynamic chart.
Time Bombing A Workbook (4-September-2007)
There may be circumstance in which you want to limit a user's access to a workbook after a period time, such as if you are distributing a trial or demonstration version of an application. This page describes a few methods to do this.
Creating Menu Items For The VBA Editor (3-September-2007)
This page describes how to write code to create menu items in the VBA Editor.
Writing Your Own Worksheet Functions In VBA (1-September-2007)
This page describes how to write custom functions in VBA. It also desribes how these function can return arrays for use with array functions.
