Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am working with a series of matrices. I want to load the first matrix with
constants. I know how to do that. I then want to use some functions like MMULT and MINVERSE and put the results (sometimes one number, sometimes a matrix) into an object where I can reference the value in a subsequent matrix operation. When I merely dimension an array, I can't seem to pass the results of a matrix function to that array or use the array within a matrix function. On a similar issue with arrays, I have a project where I want to delete mutliple sheets based upon some selection criteria. I could do it one at a time, but it gets annoying answering the question "Do you want to delete". Therefore I'd like to delete and array of sheets. When I record the action of grouping sheets and then deleting them, I notice it uses "Array(sheet1,sheet2,sheet3)". Is there a way I can load an array with the sheets I want to delete and then issue one delete statement? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula help - Sum results Pass or Fail | Excel Worksheet Functions | |||
pass variable from one workbook to another | Excel Discussion (Misc queries) | |||
Pass a variable into a range? | Excel Programming | |||
Using Public to Pass Variable | Excel Programming | |||
How to pass variable value between macros | Excel Programming |