Hello all. As always, TIA!
I have a cell previously named so would like to use that rather than (MATCH(RC-9). My best isn't working:
.FormulaR1C1 = "=IF(ISERROR(MATCH(Range(ws_3Admin_UserLogOn).Offset(1,0),0)),""No Record"", INDEX(ws_2Users_RngEmpTyp, MATCH(Range(ws_3Admin_UserLogOn).Offset(1,0),ws_2Users_RngLogOn,0)))"
Appreciate the look.
Ron
I have a cell previously named so would like to use that rather than (MATCH(RC-9). My best isn't working:
.FormulaR1C1 = "=IF(ISERROR(MATCH(Range(ws_3Admin_UserLogOn).Offset(1,0),0)),""No Record"", INDEX(ws_2Users_RngEmpTyp, MATCH(Range(ws_3Admin_UserLogOn).Offset(1,0),ws_2Users_RngLogOn,0)))"
Appreciate the look.
Ron