Object variable or With variable not Set

  • 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:


    rngCurrDate.EntireRow.Select


    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
    Ted

  • Pretty sure, I have every date in the current year in a column, and ask it to find today's date. (It finds it okay on my version of Excel (XP) but not the version at work...) :(

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!