Author |
Message |
Topic: MINVERSE FUNCTION, ERROR 13 TYPE MISMATCH |
ddanmcgrew
Replies: 1
Views: 19391
|
Forum: General Excel VBA Posted: Mon Jun 29, 2009 1:54 pm Subject: MINVERSE FUNCTION, ERROR 13 TYPE MISMATCH |
The problem was not with the code. The Matrix is singular which means the determanent = 0 and is not invertable
Dangerous Dan Mcgrew |
Topic: MINVERSE FUNCTION, ERROR 13 TYPE MISMATCH |
ddanmcgrew
Replies: 1
Views: 19391
|
Forum: General Excel VBA Posted: Fri Jun 26, 2009 4:56 pm Subject: MINVERSE FUNCTION, ERROR 13 TYPE MISMATCH |
I am writing a large program that uses matrices to calculate stresses in beams. I need to invert large (nxn) matrices. The matrix will vary from 60 to 200 rows and columns. I get a runtime ERROR 13, T ... |
Topic: Passing and Returning Arrays |
ddanmcgrew
Replies: 0
Views: 15508
|
Forum: General Excel VBA Posted: Sat May 23, 2009 4:56 pm Subject: Passing and Returning Arrays |
I have written a great program to run in excell
It has a Main procedure which calls about 12 subroutines or functions
The program writes data to a worksheet in the subroutines
The subs then add and ... |
Topic: Date and time stamp |
ddanmcgrew
Replies: 2
Views: 10727
|
Forum: General Excel VBA Posted: Fri Dec 05, 2008 3:49 pm Subject: Date and time stamp |
Thanks
What I had figured out while waiting for a reply was if I put the Excell function "NOW" somewhere on the spreadsheet (Out of view)
Then I created a string variable Time, assigned th ... |
Topic: Date and time stamp |
ddanmcgrew
Replies: 2
Views: 10727
|
Forum: General Excel VBA Posted: Tue Dec 02, 2008 5:00 pm Subject: Date and time stamp |
I have written a macro for an engineering application.
I want it to Date and time stamp the output page so later runs can be
easily distinguished from previous runs of the macro.
The user puts data ... |
Topic: Excell Function not defined ? |
ddanmcgrew
Replies: 2
Views: 13334
|
Forum: General Excel VBA Posted: Thu Nov 20, 2008 4:33 pm Subject: Excell Function not defined ? |
Thanks a lot.
I am new to coding, but this is huge for me
Thanks a lot
New Structural Engineer
Dan C. |
Topic: Excell Function not defined ? |
ddanmcgrew
Replies: 2
Views: 13334
|
Forum: General Excel VBA Posted: Fri Nov 14, 2008 4:29 pm Subject: Excell Function not defined ? |
I am writing a macro
users enters numbers in cells on "Input" workshhet.
macro grabs numbers performs math functions on them.
and loops thru approx 20 input cells
everytime this fun ... |
|