Trying to run a simple auto filter one for sheet1 and a different filter value on sheet 2. The range for the filter needs to be variable code I wrote is in the photo I don't know why it says this range is not valid. Even when I did Sheets(2).Select or Sheets(1).Select I could not get them to function on there own sheets respectively. View attachment 255
[Solved] Auto filter error application defined or object defined error
- Thread starter bino1121
- Start date
Hello bino121,
It's great to hear. If you face any Excel-related problems in the future. Keep posting here.