Hi,
A formula with Evaluate works fine in a test workbook.
All results are good.
Exactly the same code returns #Value in the workbook I should use (that contains other macros).
The error code is 2029.
In addition, when I only put in the sheet the formula resulting from the code (either when debugging or directly in the code), for instance
, the result is correct if I do Ctrl+Shft+Enter in the cell where the formula is .Please Login or Register to view this content.
As a consequence, what I understand is that the formula is not evaluated by Application.Evaluate.
Any hints ?
The following is part of the code
Any help would be appreciatedPlease Login or Register to view this content.
Thanks in advance
Dom
Bookmarks