Hi,
It doesn't work,
It should filter the data in sheet(data) with the criteria in "A4:A42" when i input RngSun
It should filter the data in sheet(data) with the criteria in "B4:B40" when i input RngMon.....
Where is the mistake ???
Sub testautofilter()
Dim RngSun As Range
Dim RngMon As...