Hi. I have a macro that selects multiple sheets and is supposed to be applying formula's to all sheets. However, the formula's are only being applied to half the sheets and I don't know why. I am not getting errors when it's selecting the sheets and I can see that all sheets are selected. Any idea why this is happening?
Code:
Sheets(Array("NY Reg", "NY Lic & Reg", "Skip in Ramco", "Annual", "90 Day", _
"Support", "NY Term", "PA Stmt #", "PA Print Card Corp", "PA Print Card State", _
"Print Card - Mark Complete", "PA Emp Ver", "PA Child Abuse", "NJN", "NJS", _
"Cherry Hill")).Select
Sheets("NY Reg").Activate
ActiveWindow.SmallScroll Down:=-15
Range("F8").Select
ActiveCell.FormulaR1C1 = "=IFERROR(VLOOKUP(RC[-5],EEMstr,2,FALSE),""Not Listed"")"
Range("G8").Select
ActiveCell.FormulaR1C1 = "=IFERROR(VLOOKUP(RC[5],Dataset,7,FALSE),""No"")"
Range("K8").Select
ActiveCell.FormulaR1C1 = _
"=CONCAT(RC[-3],"","",""; "",R7C[-2],"":"","" "",RC[-2],"","",R[-1]C10)"
Range("K8").Select
ActiveCell.FormulaR1C1 = _
"=CONCAT(RC[-3],"","",""; "",R7C[-2],"":"","" "",RC[-2],"","",R7C10,"":"","" "",RC[-1])"
Range("L8").Select
ActiveCell.FormulaR1C1 = "=CONCAT(RC[-11],"" "",RC[-9])"
Range("M8").Select
ActiveCell.FormulaR1C1 = "=IFERROR(DATEVALUE(RC[-9]),""Null"")"
Range("N8").Select
ActiveCell.FormulaR1C1 = "=IF(ISBLANK(RC[-13]),""Null"",VALUE(RC[-13]))"
Range("N9").Select
Last edited by a moderator: