ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how can i build a three variable data table in excel ? (https://www.excelbanter.com/excel-discussion-misc-queries/1309-how-can-i-build-three-variable-data-table-excel.html)

Solario

how can i build a three variable data table in excel ?
 
I know it is feasible but I can't figure out how to do it.

Frank Kabel

Hi
not really sure what you mean with this. Could you give an example?

"Solario" wrote:

I know it is feasible but I can't figure out how to do it.


Dave Peterson

Maybe??

dim myTable(1 to 2, 1 to 8, 1 to 17) as variant

mytable(1,1,1) = "hi"
mytable(1,1,2) = "there"
.....
mytable(2,8,17) = "whew! that's a lot of entries"



Solario wrote:

I know it is feasible but I can't figure out how to do it.


--

Dave Peterson


All times are GMT +1. The time now is 07:39 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com