I have this code in my module that when the Reset Link is clicked it adds a formula to a cell:
It comes up with an error:Code:Private Sub lblReset_Click() Sheets("Employee Feed").Visible = True Sheets("Employee Feed").Activate Range("A3").Select ActiveCell.FormulaR1C1 = "=REPLACE(A7,6,1," - ")" End Sub
"Type Mismatch"
What could the problem be??




Reply With Quote