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