Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cannot recalculate
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cannot recalculate
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. On 09/05/2011 08:43, Sonnich Jensen wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Recalculate in VBA | Excel Discussion (Misc queries) | |||
Recalculate changes only | Excel Discussion (Misc queries) | |||
My VBA Function Won't Recalculate | Excel Programming | |||
Won't recalculate | Excel Discussion (Misc queries) | |||
will not recalculate | Excel Worksheet Functions |