Error in a Code. Object variable or With block variable not set????

[ciapul12]

Hi All :-)

I am getting an error in my code and have no clue what is wrong?? It was working before and now I am getting this :
Run time error 91
Object variable or With block variable not set



This is the whole code:

Please Login or Register  to view this content.

Thanks for help
Dan

[Norie]

What is MyRange?

[ciapul12]

No Idea Mate I got this from my Buddy. so not really sure what this mean????

[Norie]

Dan

Can you upload an example workbook?

Click on GO ADVANCED and use the paperclip icon to open the upload window.

[AnthonyBlignault]

The MyRange could differ from workbook to Workbook

[ciapul12]

Not too sure as my project is huge and contains sensitive data.
Let me have a look...

[ciapul12]

Well I can't do it as I would have to breakdown the whole file which will have an impact on the code as some codes referring to different userforms which I can't show.....

[Norie]

Do you know anything about the code you posted and/or what MyRange is meant to be?

Is there code elsewhere that defines it?

[ciapul12]

Hi All
I have sorted it please see the below code, it had a range missing.....

Please Login or Register  to view this content.

Thanks