imback2nite
Board Regular
- Joined
- Oct 30, 2004
- Messages
- 203
- Office Version
- 2003 or older
- Platform
- Windows
I'm actually having problems with a formula disappearing after calculation. I enter the formula and it calculates. Next in the cell is the calculation but no formula. So I would like to put the formula below to be entered, calculated, copied and pasted as the calculation via a Command button. Murphy's Law ensued. Now I'm having problems with the formula in VBA. It is a bit lengthy and I've entered problems into VBA before but this one is giving be a headache. I've tried the Create Macro but all I get is 'Unable to record'. Any help would be appreciated. I have six more formulas just like it.
Excel Formula:
=IF('Group Graphs'!$P$4='Group Graphs'!$R$11,SUMPRODUCT(COUNTIF(INDIRECT("'"&Emps&"'!$B$12:$C$88"),$P$4))+SUMPRODUCT(COUNTIF(INDIRECT("'"&Emps&"'!$Q$12:$R$88"),$P$4))+SUMPRODUCT(COUNTIF(INDIRECT("'"&Emps&"'!$AF$12:$AG$88"),$P$4))+SUMPRODUCT(COUNTIF(INDIRECT("'"&Emps&"'!$B$12:$C$88"),$R$12))+SUMPRODUCT(COUNTIF(INDIRECT("'"&Emps&"'!$Q$12:$R$88"),$R$12))+SUMPRODUCT(COUNTIF(INDIRECT("'"&Emps&"'!$AF$12:$AG$88"),$R$12)),SUMPRODUCT(COUNTIF(INDIRECT("'"&Emps&"'!$B$12:$C$88"),$P$4))+SUMPRODUCT(COUNTIF(INDIRECT("'"&Emps&"'!$Q$12:$R$88"),$P$4))+SUMPRODUCT(COUNTIF(INDIRECT("'"&Emps&"'!$AF$12:$AG$88"),$P$4)))