Forum Discussion
Subtraction macro showing an error run time error 1004 application-defined object-defined
How do I resolve the subtraction code below as it is showing an error message: "error run time error 1004 application-defined object-defined" Sub subract()
Dim ws As Worksheet...
Hi HansVogelaar , after correcting it to
ws.Range("G2:G" & wsLastrow).NumberFormat = "#,##0.00", my results are populated as #value.
Tried using this code below for a separate workbook, it does work.
ws.Range("G2:G" & wsLastrow) = Evaluate("E2:E" & wsLastrow & "-F2:F" & wsLastrow)
not sure why it is populating #value now for this workbook, is it due to blank cells in row F?
That's impossible to know without seeing the workbook
- Apologies for the false alarm, I managed to rectify the issue by placing the macro into a module. Managed to get the code working nicely.
Thanks for the feedback.