Getting Run-Time error 1004 and put a holidays dates

[Sachin536]

Hi,

pls enclosed herewith sample excel files.
in this, I had to use an advanced filter function + macro to run automatic data.

when I assign in refresh shape and try to RUN get a run time error of 1004.

pls help

MY SECOND Query is pls suggest me in attached date sheet i.e. i am trying to insert a holydays in the date columns.

which means suppose and e.g. when a raw date is updated then automatically comes directly working days.

PLS SUGGEST

also, i had enable macro in through TRUST CENTER

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Macro getting Run time error 1004
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.