outlawdevil
Board Regular
- Joined
- Jun 30, 2009
- Messages
- 238
I have a macro that will filter the data based on category and copy and paste up until last row to another sheet. I will run into runtime error if the predefined critieria Category is not there so I inserted "On Error resume next" to all the filter categories to handle error no cell found. Is there any drawback to use it like this? So far the code is running fine. Thanks.