VBA Run-time error '91' In Excel 2013

Hi, I wonder whether someone may be able to help me please.

I made the following post on this forum earlier in the week.

http://www.excelforum.com/excel-prog...11#post3400811

As you can see, I was really very fortunate that @jaslake was very kind enough to provide a solution for this. However, unfortunately, as you will also see, I'm having trouble in running the code, because when doing so, I receive the following error:

Run-time error '91' object variable or With variable not set

What is even more perplexing, is that @jaslake has no problems at all.

I'm clearly doing something wrong, perhaps in the way I've set up my version of Excel, but I just thought I'd pass this out to a wider audience, to see if someone may be able to offer a solution which may help in me being able to run the script.

Many thanks and kind regards

Hi @JosephP, thank you very much for taking the time to reply to my post.

I've amended the code you suggested, but unfortunately I'm still receiving the same error. My apologies.

Kind Regards

Hi @JosephP, thank you very much for coming back tome so quickly with this, and I'm sorry to be a burden.

The line which I receive the error from is line 104.

Many thanks and kind regards

Hi @JosephP, my apologies, I took the line number from the VBA debug screen.

The line which I receive the error from:

Please Login or Register  to view this content.

Many thanks and kind regards

Hi, the line before the aforementioned is this:

Please Login or Register  to view this content.

Many thanks and kind regards

Hi, please find the file attached below.

Many thanks and kind regards

Hi @JosephP, I'm very sorry to trouble you, but I noticed a copy and paste error on the "Projects Output" sheet, my apologies.

Please find the revised correct file attached.

Many thanks and kind regards

Hi @JosephP, thank you very much for coming back to me with this.

I've just looked at the latest file I uploaded and this does contain date headers in row 4 on the "Projects Output" sheet, so I'm a little confused.

Many thanks and kind regards

Hi @JosephP, thank you for coming back to me with this and my apologies for not grasping your explanation. I've tried the code you kindly provided, but unfortunately I'm still receiving the same error.

I think I may have to go back to the 'drawing board' with this, so please don't spend anymore time on this.

Thank you for all your time, trouble and patience.

Kind Regards