VBA formula not calculating... help!

[Jed Shields]

Hello all,

I've got some code that writes a formula in one cell, drags it accross and then down to populate a table. The trouble is that the enire table shows zero's. If I higlight the formula then it gives me the correct result. If I press F9, Ctrl Alt F9 etc. then that also doesn't work.

Any idea what's going on?

Cheers,

Jed

 

[Jed Shields]

I found this onine and it's done the trick. I guess the enble.calculations must have been stuck on false somewhere..

ThisWorkbook.Worksheets("Twilight 1").EnableCalculation = False
 ThisWorkbook.Worksheets("Twilight 1").EnableCalculation = True
 ThisWorkbook.Worksheets("Twilight 1").Calculate