G
Guest
I have written a function in Excel's Visual Basic editor. It accepts two
arrays, one of Integer's and one of Double's.
The function seems to compile just fine and other functions are working well
for me, so I semi know what I am doing.
In the spreadsheet, I would like to select a range of cells and pass them as
the integer array. I would like to do the same for another contiguous range
of cells to serve as the Double array.
I tried simply doing just that but got errors in the spreadsheet.
How do I do this? Is there some function in the spreadsheet that converts a
range of cells into an array of numerical values?
Or do I need to adapt the function to work in the spreadsheet's way of doing
things and make it receive cell references from which it extracts the
numerical values?
TIA,
BE
arrays, one of Integer's and one of Double's.
The function seems to compile just fine and other functions are working well
for me, so I semi know what I am doing.
In the spreadsheet, I would like to select a range of cells and pass them as
the integer array. I would like to do the same for another contiguous range
of cells to serve as the Double array.
I tried simply doing just that but got errors in the spreadsheet.
How do I do this? Is there some function in the spreadsheet that converts a
range of cells into an array of numerical values?
Or do I need to adapt the function to work in the spreadsheet's way of doing
things and make it receive cell references from which it extracts the
numerical values?
TIA,
BE