I have done all procedures to use GCD in Excel.
When I open a new instance of excel, and I create a formula like
=gcd (A2:A4), it works fine.
There is still a problem.
When the program opens an instance of Excel, the formula in the cell returns
#NAME?, although "analisis tool" box In add ins options is checked.
This is the command line to put the formula in Excel.
ExcelSheet.Cells(StartRow, 7).Formula = "= gcd(G" & StartRow + 1 & ":G" & EndRow & ")"
- If I copy the fine working formula from its sheet and paste into the bad working cell,
it works fine, too. !!!!!
- If I copy the bad working to the good working, it doesn´t work too (
)
How can I solve this problem?
Thanks for help.