On Mon, 9 Jan 2006 14:37:31 -0600, cooter24
wrote:


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.

Why not use the networkdays function, with the optional holidays argument,
within VBA to generate your list of weekdays?

You can set a reference to atpvbaen.xls in VBA and then use the ATP functions
directly.

No matter what, you'll still need a list of the holiday dates someplace.
--ron