Autofiltering error 1004

[paulcherianc]

Hi,

Based on the dates provided on the cells "I1" and "J1" (linked "S3" where the user will input on going month date) the macro will auto filter "B5:Y" on the following:

1. First filtering will be done on Contract Signed ("F5") and copy the filtered data to the table then macro will delete the data appearing in HSE Charter Signed ("G6: till end) column.
2. Next filter will be on HSE Charter Signed ("G5") and copy the filtered data to the same table under the above data copied. Then macro will delete the data appearing in Contract Signed ("F6": till end) column.

I have attached a sample file where you can see the error while changing the date on "New Register" "S3" and get me the codes as stated above.

Can anyone please fix my issue!

 

[Marc L]

Hi !

If really the error comes from using a filter,
just activate the Macro Recorder and operate manually :
you will get a correct filtering code …

If not, update the title of this thread according to the codeline
where this error occurs and post about this codeline …
​

 

[NARAYANK991]

Hi ,

Now the error will no longer appear , but I do not see the macro doing anything.

Can you check the attached file ?

Narayan