Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MMULT( )
Is there a better way to multiply matrixes from VBA than calling MMULT? I
ask because MMULT does what I need, and is very fast, but when I call it from VBA to multiply matrixes on various sheets, the function seems to force that data sheet to become the active sheet. With the rest of my program I can have a summary sheet in view that keeps showing progress. When I incorporated MMULT into my VBA though (rather than my own VBA multiply code) the screen is constantly flashing through all the sheets. Killing ScreenUpdate stops that problem, but then of course one can't see the summary sheet updating either. I haven't come across any other worksheet function, that when called from VBA steals the active focus like this. I'm trying to run this strictly from VBA so I can keep AutoCalculation turned off. That makes things much faster for me, but gets me into this problem of a fast way to multiply matrixes from VBA. Thanks. Bill |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 - MMULT | Excel Discussion (Misc queries) | |||
MMULT | Excel Worksheet Functions | |||
MMULt Worksheet Function | Excel Worksheet Functions | |||
Application.WorksheetFunction.MMult | Excel Programming | |||
application.worksheetfunction.mmult help | Excel Programming |