VB Array - Select column

[Troubled User]

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)

 

[RyanH]

You can use this to name the used range in Col. 3, then add it to your array.
I hope this helps.


Sub LastRow()

Dim LastRow As Long
Dim myRange As Range

LastRow = Sheets("Sheet1").Cells(Rows.Count, 3).End(xlUp).Row

Set myRange = Sheets("Sheet1").Range("C1:C" & LastRow)

CalculatedIRR = Application.WorksheetFunction.IRR(TheIRRArray(myrange), .01)

End Sub

 

[Alan Beban]

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

 

[Troubled User]

Thanks Alan, EXACTLY what I needed.

Col3Array=Application.Index(FiveColumnArray,0,3)

Alan Beban