15-10-2001, 08:23 AM

Each of the two following lines of code work separately but not the third. Can someone help please?

ActiveCell.Formula = '=SUM(RC[1]:RC[10])'

ActiveCell.Formula = '=t7'

ActiveCell.Formula = '=t7' - '=SUM(RC[1]:RC[10])'

ActiveCell.Formula = '=SUM(RC[1]:RC[10])'

ActiveCell.Formula = '=t7'

ActiveCell.Formula = '=t7' - '=SUM(RC[1]:RC[10])'