I'm using VBA with Excel 2000. I'm trying to store formulas in cells in one sheet to copy from another sheet. The formula I'm trying to store looks like this: =IF(Input!A$10="";"";Input!A$10). I get a run-time error (1004) when I try to do wks.Range.Formula = formula. If the formula is not conditional - =Input!A$10) - it works fine. Any clues?
Any help would be greatly appreciated. -- Ham Rutledge
Any help would be greatly appreciated. -- Ham Rutledge