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)

Hi Alex,
Someone reported a similar problem, and the TrimALL macro
fixed problem
http://www.mvps.org/dmcritchie/excel/join.htm#trimall

The macro remove spaces and reenters content, so that you
use your actual cell formatting that you may have set after
you entered your data. Changing a number format on a number
is effective immediately, but crossing between text and numbers
will not take effect until data is reentered.

Your other items are in effect reentering the data, whether F2
or changing "=" to "="
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"AlexT" wrote in message oups.com...
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)