Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Export 1-dimensional array values to a two-dimensional table?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Export 1-dimensional array values to a two-dimensional table?
On Nov 8, 7:15 am, Laurie wrote:
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Export 1-dimensional array values to a two-dimensional table?
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 "carlo" wrote: On Nov 8, 7:15 am, Laurie wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing a two-dimensional, one row array to one-dimensional | Excel Programming | |||
permutation of values in 2 dimensional array | Excel Programming | |||
Create One-Dimensional Array from Two-Dimensional Array | Excel Programming | |||
2 Dimensional Array | Excel Programming | |||
2 Dimensional Array | Excel Programming |