Hi,

I want to do something, let's say nonconventional. Last fall, I studied in a
Java class, and we created virtal tables in memory where we put data in it.
It was purely an object in Eclipse Java program. No database was supporting
the data, only the object in memory. So you could get one data by getting it
in the precise row in my virtual table when my list was done. It allowed me
to creating dynamic tables, where the number of data was not always the same
one. Now I want to do it in Excel VBA. You could say, "why bothering with
that! Just throw thoses damn values in cells and you'll get the result!" :)
Well, I think it's an interesting challenge, and it's simplier in my view
once you know the concept. So you can do lot's of mathematic equations with
this virtual table. So does anyone can point me something to help me on
virtual tables in memory?
Thanks

Jean-Jérôme Doucet

--
Message posted via http://www.officekb.com

Hi Jean-Jérôme,

Look at 'Using Arrays' in VBA Help.

Also, do a Google searh of this group's archives for 'Array' to find a
myriad of examples.


---
Regards,
Norman



"Jean-Jérôme Doucet via OfficeKB.com" wrote in
message ...
Hi,

I want to do something, let's say nonconventional. Last fall, I studied in
a
Java class, and we created virtal tables in memory where we put data in
it.
It was purely an object in Eclipse Java program. No database was
supporting
the data, only the object in memory. So you could get one data by getting
it
in the precise row in my virtual table when my list was done. It allowed
me
to creating dynamic tables, where the number of data was not always the
same
one. Now I want to do it in Excel VBA. You could say, "why bothering with
that! Just throw thoses damn values in cells and you'll get the result!"
:)
Well, I think it's an interesting challenge, and it's simplier in my view
once you know the concept. So you can do lot's of mathematic equations
with
this virtual table. So does anyone can point me something to help me on
virtual tables in memory?
Thanks

Jean-Jérôme Doucet

--
Message posted via http://www.officekb.com