Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
refreshing outout value before tranferring into a matrix
I have written a macro to create a matrix using the output from a complex
series of iterative inputs (and other various fixed inputs). I have created the code so it works when a simple formula is used, but when I substitute in a more complex formula I believe the output cell is not refreshing fast enough with the correct value before inputing the value into the matrix. Are there any suggestions to make the output value refresh after each time the iterative inputs are added, so the correct values are generated in the matrix? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
refreshing outout value before tranferring into a matrix
Application.Calculate just before writing should force it
-- Regards, Tom Ogilvy "Cammy" wrote: I have written a macro to create a matrix using the output from a complex series of iterative inputs (and other various fixed inputs). I have created the code so it works when a simple formula is used, but when I substitute in a more complex formula I believe the output cell is not refreshing fast enough with the correct value before inputing the value into the matrix. Are there any suggestions to make the output value refresh after each time the iterative inputs are added, so the correct values are generated in the matrix? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I transpose nXm matrix to mXn Matrix | Excel Worksheet Functions | |||
NOW() and SECOND() not refreshing | Excel Worksheet Functions | |||
Tranferring names defined in one excel workbook to another workboo | Excel Discussion (Misc queries) | |||
links changed since tranferring files from old to new laptop | Links and Linking in Excel | |||
Tranferring Text from Excel to a Header in Word | Excel Programming |