Search: | |||||

| ||||

Home » Forum » MS Office | RSS Feeds |

I want to write an Excel VBA formula that would return an array of

doubles to a range of cells in Excel, without using the Array object

in VBA.

The problem, as I understand, is that the Array object needs the

arglist to be comma separated. I want to simply do a calculation on

an array of doubles, and return that array to Excel.

Is that possible?

Ex.

Function simple_test(returns As Range)

Dim dec3() As Double

Dim i, ct As Integer

ct = WorksheetFunction.count(returns)

ReDim dec3(0 To ct - 1)

For i = 0 To ct - 1

dec3(i) = returns(i)

Next i

simple_test = dec3

End Function

Didn't find what you were looking for?
Find more on formula returns to multiple cells, without Array object?
Or get search suggestion and latest updates.

Related Topics:

- Using an array formula as a hyperlink cell reference
- Copy Value produced by formula in cell C3 to cell D3
- clearing cells value without deleting the formula I've made in cell from excel formula , HOW?
- VBA Array - return value to a cell
- VBA code to add values in two cells which have formulas
- Ctrl+Shift+Arrow Fails To Select Cells When Used in Formula Bar
- cells containing formula that refer to user-defined VBA function
- VBA or array formula?
- Array Formula
- Copying current cell's value to another cell
- Making objects wait/threads return objects
- sorting an array in VBA without writing it in excel sheet
- Multiple icons in JTable cell
- function that returns a String Array
- how are cell coordinates referenced on a clicked cell
- to see if text in a cell in a column is contained in any cell
- Moving data in the last cell of row to another column cell
- Action taken by Excel when a condition causes a cell's value
- Function needed to split the content of a cell intomany cells
- Function needed to split the content of a cell into many cells
- Finding and replacing the cell next to a cell with a certain string
- Update a cell based on a DDE updated cell value
- active cell no longer advances to cell below
- A Paragraphs in one cells --> convert into a line in per cells
- Cell validation based on the contents of previous cell