pcarmour
01-14-2014, 03:08 PM
Hi,
I have an absolute reference formula that I need to change to always go to the second row ie. A2 G2 W2 wherever it is used instead in this example 67 above.
ActiveCell.FormulaR1C1 = _ "=SUMPRODUCT(COUNTIF(R[-67]C:R[-1]C,{""HBA1"";""HBA2"";""HBA3"";""HBA4"";""HBA5"";""HBA6"";""HBA7"";""HBA8"";""HBA9"";""HBAF"";""VANT1"";""VANT2"";""VANT3"";""VANT4"";""VANT5"";""BEAUA"";""BEAUM"";""BEAUX""}&""""))"
Any help is always appreciated.
I am working with Windows Home Premium version 6.1.7601 SP 1 Build 7601and Excel version 14.0.6123.5001 (32 bit)
I have an absolute reference formula that I need to change to always go to the second row ie. A2 G2 W2 wherever it is used instead in this example 67 above.
ActiveCell.FormulaR1C1 = _ "=SUMPRODUCT(COUNTIF(R[-67]C:R[-1]C,{""HBA1"";""HBA2"";""HBA3"";""HBA4"";""HBA5"";""HBA6"";""HBA7"";""HBA8"";""HBA9"";""HBAF"";""VANT1"";""VANT2"";""VANT3"";""VANT4"";""VANT5"";""BEAUA"";""BEAUM"";""BEAUX""}&""""))"
Any help is always appreciated.
I am working with Windows Home Premium version 6.1.7601 SP 1 Build 7601and Excel version 14.0.6123.5001 (32 bit)