VBA - List Dates excluding Weekends and Holidays

Really appreciate if someone could help. This may be a little long. I apologize.

I currently have a function in which when I enter a date that is not a trading day it returns an error.

The Code is:

Please Login or Register  to view this content.

Now I have to be able to create a list of dates using vba excluding weekends and the holidays above. What I have now is:

Please Login or Register  to view this content.

This actually returns a list of dates excluding the weekends for the year 2011, but is very limited and doesn't exclude the holidays I mentioned.
Could someone help me modify mine or if there's a better solution would be greatly appreciated. Thank You

How about:

Please Login or Register  to view this content.

@tykhoo,

Please use code tags next time...Thanks.