Create an array of separate cells
 

Hi all,

I would like to know how I can create an array of 1 column with cells
that are not in order, that contains the data that is in cell A1, C3,
and E5. And use that array created in the formula FVSCHEDULE.

Something like this: "FVSCHEDULE (principal, MyArray (A1, C3, E5))"

Please excuse my English.

Create an array of separate cells
 

On Wed, 21 Mar 2012 20:12:29 -0700 (PDT), Rickemil wrote:

Hi all,

I would like to know how I can create an array of 1 column with cells
that are not in order, that contains the data that is in cell A1, C3,
and E5. And use that array created in the formula FVSCHEDULE.

Something like this: "FVSCHEDULE (principal, MyArray (A1, C3, E5))"

Please excuse my English.

You can do this with a simple User Defined Function:

To enter this User Defined Function (UDF), <alt-F11 opens the Visual Basic Editor.
Ensure your project is highlighted in the Project Explorer window.
Then, from the top menu, select Insert/Module and
paste the code below into the window that opens.

To use this User Defined Function (UDF), enter a formula like

=FVSCHEDULE(principal,MyArray(A1,C3,E5))

in some cell.

======================================
Option Explicit
Function MyArray(ParamArray Schedule() As Variant) As Variant
MyArray = Schedule
End Function
===========================

Create an array of separate cells
 

On 22 mar, 07:23, Ron Rosenfeld wrote:
On Wed, 21 Mar 2012 20:12:29 -0700 (PDT), Rickemil wrote:
Hi all,

I would like to know how I can create an array of 1 column with cells
that are not in order, that contains the data that is in cell A1, C3,
and E5. And use that array created in the formula FVSCHEDULE.

Something like this: "FVSCHEDULE (principal, MyArray (A1, C3, E5))"

Please excuse my English.

You can do this with a simple User Defined Function:

To enter this User Defined Function (UDF), <alt-F11 opens the Visual Basic Editor.
Ensure your project is highlighted in the Project Explorer window.
Then, from the top menu, select Insert/Module and
paste the code below into the window that opens.

To use this User Defined Function (UDF), enter a formula like

=FVSCHEDULE(principal,MyArray(A1,C3,E5))

*in some cell.

======================================
Option Explicit
Function MyArray(ParamArray Schedule() As Variant) As Variant
*MyArray = Schedule
End Function
===========================

Thank you so much,

My respect for you.

Excuse me Ron, could you recommend me something (BOOK, WEB) to learn
VBA from beginner, intermediate to advanced.

Thanks Again.

Create an array of separate cells
 

On Thu, 22 Mar 2012 07:39:33 -0700 (PDT), Rickemil wrote:

Thank you so much,

My respect for you.

Excuse me Ron, could you recommend me something (BOOK, WEB) to learn
VBA from beginner, intermediate to advanced.

Thanks Again.


Glad to help. And no, I don't know of any resources such as you describe for learning VBA. My personal learning evolved over many years, mostly by trial and error.