Reply to thread

Message: [QUOTE="Andy Pope, post: 6278506"] Hi Bernard, I had trouble reproducing the problem until I used a formula that referenced the same row as where I was entering the formula. And remember to include the absolute reference to the column, The problem is there in a plain SUM formula also. So in D1 the formula =SUM($A1) recorded syntax is ActiveCell.FormulaR1C1 = "=SUM(RC1)" The recorder should really produce a zero row reference in order to avoid cell name clashes. ActiveCell.FormulaR1C1 = "=SUM(R[0]C1)" Cheers Andy -- Andy Pope, Microsoft MVP - Excel [URL]http://www.andypope.info[/URL] [/QUOTE]