Hello,

I am fairly new to programming so bear with me. I have a number of sheets that I have to update monthly which I am trying to automate. I have been able to do everything but avoid pasting holidays when I use autofill and paste special weekdays. Is there anway, similar to the networkdays function, in programming where I can only pastespecial actual workdays and avoid the holidays? I know I can use a look up functon and then delete but I would rather avoid that. Any help is appreciated.