Jenst

09-21-2016, 04:27 AM

Hi!

Following problem I found no solution on:

I have a spread sheet where insert formulas. Some of the formulas have a minus in there. This ones are not calculating after they have been inserted. The weird thing is that if I click on the cell go into the data entry bar and click enter, the in the cell starts to work.

An example of minus formula:

Range("AT3").Formula = "=(AA3-AS3)/AA3"

Range("AT3").Copy

Range(Cells(4, 46), Cells(3 + i, 46)).Select

ActiveSheet.Paste

I have tried so far:

ActiveSheet.EnableCalculation = False

ActiveSheet.EnableCalculation = True

Application.CalculateFull

Many Thanks, Jens

Following problem I found no solution on:

I have a spread sheet where insert formulas. Some of the formulas have a minus in there. This ones are not calculating after they have been inserted. The weird thing is that if I click on the cell go into the data entry bar and click enter, the in the cell starts to work.

An example of minus formula:

Range("AT3").Formula = "=(AA3-AS3)/AA3"

Range("AT3").Copy

Range(Cells(4, 46), Cells(3 + i, 46)).Select

ActiveSheet.Paste

I have tried so far:

ActiveSheet.EnableCalculation = False

ActiveSheet.EnableCalculation = True

Application.CalculateFull

Many Thanks, Jens