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
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