Forum Discussion
run time error 1004
Hi, could anyone help me with this problem? Sub ButtonCode() Dim N As Long N = Cells(Rows.Count, "C").End(xlUp).Row + 1 Cells(N, "C").Value = (Cells(N - 1, "C").Value) * (1 - Range("Shee...
Cells(N, "C").Value = (Cells(N - 1, "C").Value) * (1 - Range("Sheet2!E5").Value)
this and subsequent similar lines are the cause of error
AdityaMahajan ur code seems fine, I am able to run it in my system.
Is it possible for u to share the file?
and I hope u have not renamed the worksheet "sheet2"?