| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB Array - Select column
Thanks Alan, EXACTLY what I needed.
"Alan Beban" wrote: Troubled User wrote: I am loading a five column Array with various pieces of information related to a cashflow series. In column 3 I have the cashoutflows and inflows, which I would then like to pass (just column 3) to the array to the IRR function. How do I select column 3 to pass to the Array? CalculatedIRR = Application.WorksheetFunction.IRR(TheIRRArray(???? ????), .01) Col3Array=Application.Index(FiveColumnArray,0,3) Alan Beban |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA: Column Select then Data Select then return to cell A1 | Excel Discussion (Misc queries) | |||
| Select values in an array | Excel Discussion (Misc queries) | |||
| How to select a single "column" of a VBA array? | Excel Programming | |||
| Help with - Sheets(Array(1, 2, 3)).Select | Excel Programming | |||
| Select Distinct from Array | Excel Programming | |||
Hybrid Mode
