Recalc Challenge

  • Thread starter Thread starter Howard Taylor [o2olap]
  • Start date Start date
H

Howard Taylor [o2olap]

I have a cutsom function in my application and need this to calculate when
running a macro from within the custom application. Eg. I have a function
called "CalculateCell" in cell A1 and need to have this calculate in Excel
while running the custom function "FunctionTest". The problem with this is
that when you use Application.Range("A1").Calculate you get an error and I
think it is the fact that you cannot Calculate in Excel when a custom
function is running. Is there any way around this. I need to calculate this
through Excel and not direct through the custom application such as most do.
There are parameters in Excel that need to be picked up.

Any help would be appreciated.
 
Back
Top