listi.netinc_db_routines: err logic = -2147217865 The Microsoft Jet database engine cannot find the input table or query 'settop'. Make sure it exists and that its name is spelled correctly.
exec settop
inc_db_routines: err logic = -2147217904 No value given for one or more required parameters.
select config_value from config where config_value = 'listi.net'

Listi.net

             


inc_db_routines: err logic = -2147217904 No value given for one or more required parameters.
select cookie from emails where email = '' and from_system = 'successalarm.com'
inc_db_routines: err logic = -2147217865 The Microsoft Jet database engine cannot find the input table or query 'goalpts'. Make sure it exists and that its name is spelled correctly.
select sum(goal_pts) from goalpts where email = '' and dt_goalpt = DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE()))

FormulaR1C1

ActiveCell.FormulaR1C1 = _
        "=IF(ISNA(VLOOKUP(R[485]C[-1],Explanations!C[-6],1,FALSE)),0,1)"

Becomes

Range("J2").Select
ActiveCell.Formula = _
       "=IF(ISNA(VLOOKUP(I2,Explanations!D:D,1,FALSE)),0,1)"  


=IF(I7="","Never Rated",I7)


I copied it from the cell