when i programatically copied and pasted a formula on a worksheet, the entire
worksheet now refuses to calculate all formulas - even simple ones, entered
manually, such as = 1+2. 0 is displayed as the result.

Cell formatting is set to standard Number, 0 Decimals and (1,234) for
negative.


Here's the code I used to copy and paste the formula:

with WorkSheetObject
.cells(9,5).formula = "=E41+E73+E105"

.Cells(9, 5).Copy
.Range(.Cells(9, 6), .Cells(9, 42)).PasteSpecial _
Paste:=xlPasteFormulasAndNumberFormats
end with

All was working fine until I ran these two lines. Had same issue earlier on
different sheet using sumif after programatically using PasteSpecial,
developed a workaround but I really need this formula to work on this sheet

Am Using Excel 2002 SP3 in WIn XP Pro. No other Office versions have been
on machine. Calculation is set to Automatic and forcing re-calulation has no
effect (Calc Now "F9" or Calc Sheet).

Any helpful comments are appreciated.