Cannot recalculate

  • Thread starter Thread starter Sonnich Jensen
  • Start date Start date
S

Sonnich Jensen

Hi

In a larger script we create some formulas with VLOOKUP, but they do
not work, instead they give us #NAME?
It happens because the VLOOKUP uses another sheets SHEET2!G:N, which
seems to cause the problem.

When done, and we go to the cell, open the formula and press enter, we
get the actual value. It works,

I tried sheet.calculate, but that does not do the trick.

Any suggestions?

WBR
Sonnich
 
Are you building the formula using USA English syntax?
Are you using .formula and using R1C1 notation (or vice versa)?

If this doesn't help (and I bet it doesn't!), you should share your code that
builds the formula.

And you should create a formula in the worksheet cell that works and share that,
too.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Recalculate formulas when active sheet switches 1
Error 1004: application or object defined error 4
Application-defined or object-defined error 2
Excel Excel Vlookup formula based on cell data 7
Copy/Paste Template to New Workbook 11
SheetCalculate fires all the time 3
force recalculation of function 5
VLOOKUP in VBA code 3

Back
Top