Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Array of data in Excel Visual Basic
Hi
I have a big 3 dimensions array of data (integers). I want to load this data the first time the workbook will run so i could use it later on in functions/formulas that I'll create in VB. example: Dim arr(10,10,10) As Integer Public Function GetData(x,y,z) As Integer GetData = arr(x,y,z) End Function How do I load the data into the arr(10,10,10) array (let say the data is in other excel file or in one of the sheets in the same workbook) I don't want to load the data every time I call the function from the worksheet - it is big data base Thanks Gaza |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Visual Basic Chart Objects array | Excel Programming | |||
how to export data from excel to visual basic | Excel Programming | |||
Get The Length of data type of excel using visual basic | Excel Programming | |||
Can I run Visual Basic procedure using Excel Visual Basic editor? | Excel Programming | |||
How do I use an array function in Visual basic .NET? | Excel Programming |