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