Forum Discussion
Solved
Runtime error 1004 Application-defined or Object-defined error
I have yet another runtime error; this time it's 1004 instead of 6. Again, this code was originally French and I did not make it myself.
The problem is that NONE of the cells in column A of the Risk Assessment sheet contains "END OF RISKS", so loop never stops until the variable row is greater than the number of rows on the sheet (1048576).
To make it work, column A MUST contain a cell with value "END OF RISKS".
Another point: you have several lines
Clear tab_value()
This should probably be
Erase tab_value()
6 Replies
It's impossible to know what causes this without seeing (a copy of) the workbook.
Here is a copy of the workbook. I'm sure that once you start looking through it you'll realize that there's A LOT wrong with it.
The problem is that NONE of the cells in column A of the Risk Assessment sheet contains "END OF RISKS", so loop never stops until the variable row is greater than the number of rows on the sheet (1048576).
To make it work, column A MUST contain a cell with value "END OF RISKS".
Another point: you have several lines
Clear tab_value()
This should probably be
Erase tab_value()
