yearrng

  1. A

    VBA using a set range inside an indirect formula

    Hi, I have the followed formula created in VBA: ActiveCell.FormulaR1C1 = "=IFERROR(IF(AND(RC[-1]=""No Data"",RC[-2]<LOOKUP(2,1/(INDIRECT(R2C22)=LOOKUP(9.99E+307,INDIRECT(R2C22))),INDIRECT(R3C22))),0.987654321,IF(AND(RC[-1]=""No...

Some videos you may like

This Week's Hot Topics

Top