Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help: selecting part of an array
I want to write a function that calls in a whole array and then doe
different things to different parts Function compress(array) topleft = array's top left cell ????? End Function Thank -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help: selecting part of an array
You might want to consider the functions in the freely downloadable file
at http://home.pacbell.net/beban. The function "SubArray", for example, takes an array, the new first column, the new last column, the new first row and the new last row, and returns the specified subarray. For the top left cell, for example, =SubArray(myArray,1,1,1,1), although myArray(1,1) is obviously more sensible for such a simple case. Ala Beban Philbyinsydney < wrote: I want to write a function that calls in a whole array and then does different things to different parts Function compress(array) topleft = array's top left cell ????? End Function Thanks --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting right part of text string | Excel Worksheet Functions | |||
Selecting part of a number in a cell | Excel Worksheet Functions | |||
Selecting the first time a number appears (part 2) | Excel Discussion (Misc queries) | |||
Selecting part of a series for a chart? | Charts and Charting in Excel | |||
Selecting used part of a range | Excel Programming |