Cannot recalculate

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
 
D

Dave Peterson

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

Top