Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sometimes range calculate doesn't work in macro. Why?
I have applications in active use in my company that under macro control
just calculate a single cell, or a range. I figure that I don't need to calculate the entire workbook when I don't need to. Usually this works fine. Every once in a while it doesn't. Once a workbook gets into such a state the only solution is to delete the range and do a calculate on the entire workbook. The one I saw today, and which motivated me to post, there was no other workbook open. Have others seen this? Any idea why? We are using xl2002. Don <donwiss at panix.com. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to update a column in a work based on another work sheet | New Users to Excel | |||
Create macro to calculate data range for a running chart | Excel Worksheet Functions | |||
TO TOM OR KEN: macro to calculate selected range | Excel Programming | |||
Excel Macro Problem, Add-in need to work in every workbook & Error:9 Subscript out of range | Excel Programming | |||
Macro that hide or unhide and not calculate or calculate | Excel Programming |