VBA created formulas won't autocalculate
If the formulae refer to the new sheet in anyway, it my
require the file be saved before they will reliably
calculate
-----Original Message-----
Frans is using 'function' rather than 'sub' in that these
are code modules and not UDF's
Application.Volatile doesn't work.
I suspect that within his code he needs to add something
like
Worksheets(naam4).Calculate
....although if Shift+F9 doesn't work, then this probably
won't
-----Original Message-----
Frans,
Try preceding your code with
Application.Volatile
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"Frans Muller" wrote in message
.com...
There is a problem, which i've been struggling with
for some time now.
I've created a workbook with a macro that creates
worksheets within
the workbook. The macro also enters formulas refering
to cells of
other worksheets.
At first everything seems to work properly in the new
worksheet.
The problem is that when I run the macro again to
create another
worksheet, the formulas in the previous created
worksheet fail to
autocalculate although "autocalculate" is on. Pressing
<F9 doens't
work as well. The only thing that works is to enter
the cell and then
press <enter. However the formulas in the new
worksheet do work
properly, right until another new worksheet is created.
Has anybody encountered this problem, and is so....
any solutions?
Thanks in advance,
Frans Muller
.
.
|