Export 1-dimensional array values to a two-dimensional table?

[Laurie]

Hi,

Now I have an array function to get a vector of values for a given age.

How can I use loops to export the array values for a set of ages?

I tried to use the age as a loop indicator but it seems not working.

Thank you very much for your help and any suggestion in advance!!!

Sincerely,
Laurie

 

[carlo]

Hi,

Now I have an array function to get a vector of values for a given age.

How can I use loops to export the array values for a set of ages?

I tried to use the age as a loop indicator but it seems not working.

Thank you very much for your help and any suggestion in advance!!!

Sincerely,
Laurie

Hi Laurie

if you could post a little bit more information we could maybe help
you better.
The loop itself shouldn't be the problem, but:
- Where do you want to export them.
- How does your array function look like.
- How are your ages built up (integer for every year, or every 5
years....?)

Carlo

 

[Laurie]

Hi Carlo,

Thanks for your reply!!

I have figured out how to export the values by using loops in the macro.

Basically, I have an array function generating a vector of values for each
age. I was planning to export the values to an Excel worksheet, with one
column for each age to hold the vector of values. When the vector of one age
had been exported, move to the next column for the next age (consecutive
integer age).

Anyway, the solution was using two offsets in one line of the code rather
than in two lines with each line having one offset of the reference.

Thanks again,
Laurie