Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Folks
I'm having a rather irritating problem with some part of my VBA-constructed worksheet not willing to recalc. To make a rather complex process short I have basically some VBA code constructing a worksheet from scratch. Everything works as expected except that a specific range doesn't recalc. * I have tried to turn auto calc on or off * I have tried to apply the Calculate to that specific range, to the enclosing worksheet or to the whole workbook. * I have tried CalculateFull * I have tried a "find & replace" to replace "=" with "=" on that range (I have found that this sometimes "unlocks" "frozen" formulas But simply pressing F9 after running my macro works just fine... Argh ! Any Idea ? (XL2000 SP3) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
aauugghhh...#div/o problems & various average formula problems | Excel Worksheet Functions | |||
Sometimes formuli in workbook don't auto update with auto-recal on | Excel Worksheet Functions | |||
tab problems | New Users to Excel | |||
RTD Problems | Excel Programming | |||
Problems merging an excel file due to code or file problems? | Excel Programming |