"Mike" wrote in message
m...

"KT_1010" wrote in message
...
On a given column I have a VBA function (which calls other functions
and accumulates the values, yielding a calculated weight for the data
on that row.) When I change the function, is there a way to allow/
force a recalc (F9, Shift-F9). Non of the data on the form has
changed, but the function to be applied to each row has been update,
so the resulting column for each row should be updated.

If I use the recalc sheet button, the value on every row in that
column is a copy of the output for the first row. [If I place the
cursor after the formula in the column I can force the function to
accurately weigh the data in that row. I can spot check some of the
rows, but I'd really like the worksheet to recalculate the value for
all 32,000 rows]

my perception is that when value changes in a dependent cell, the
formula will fire and update the target cell. I had understood, the
"Recalculate Worksheet" would force a recalculation for every cell
that is derived from a function. Apparently that doesn't work for me
either. [[ it calculates the first value, and then copies the value
into that column for all the rows, or alternatively shows a value
error.]

oh. yes. I'm very new at this. I am still trying to find the RTFM
that relates, but it's very hard to find.

Have you tried Application.Send ("^%{F9}")


Whoops that should read Application.SendKeys ("^%{F9}")