Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi!
In a class module I have declared a matrix ( name(120,120) as double), i have a sub procedure that does som calculations, so that I have the information I want to use for calculations stored in that matrix. In a generall module procedures I want to have access to a column of this matrix, but I haven't got a clue as how to get hold of it. Preferably I would like to assign a double variable of length 120 the contents of a column of my choice belonging to an instance of that class. Since the variable is of type (120,120)double I can not access it in the usual way by the syntax object.matrix(i,j). Also, is there a way of selecting multiple indexes in a vector? In computer algebra software such as Matlab,S-plus or R, I am used to be able to specify a particular range of indexes , i.e matrix(1:90,120) where 1:90 is row 1 to 90, and 120 the 120th column. Is there any way of doing such an opperation using VBA/Excel. Any suggestion on how to solve my problem, or links to sites where I can read up on these matters will be greatly apprectiated. Stig |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Class modules: parametrize class object fields | Excel Programming | |||
VBA Class Modules | Excel Programming | |||
Basic question - modules and class modules - what's the difference? | Excel Programming | |||
Class Modules | Excel Programming | |||
Class Modules vs Modules | Excel Programming |