Excel 97 - Access Violation

[Phoenix22]

Hello,

I wrote a macro last week (which worked fine). Now when I run it, I keep getting the "Access violation at 0 x c000005" error message.

The code screws up at the following line:
ActiveCell.FormulaR1C1 = average_formula

I've tried subsituting the above with the below and it still screws up:

Cells(row_index, ccspernas_col) = average_formula

I have verified manually that the average formula is referring to correct cell references.

Any help would be much appreciated, thanks.

 

[bronc]

not too sure
access violation may refer to ram access violation i.e. an OS fault i.e windows re-install?