Please can someone have a look at the attatched Holiday Chart I'm working on.
I have Office XP and it works fine, however - when I use it at work (not sure what version of Excel they have) I get the following error in the Workbook_Open method:
Run time error 91; Object variable or With variable not Set.
It occurs at the following part of my code:
I don't understand because I've set the variable using the .Find function. ie - Set rngCurrDate = ActiveSheet.Columns(2).Find( etc, etc.
Please help me :flame:
Thanks very much