Application-Defined or Object-Defined Error

Evening ladies & gents,

I got this piece of code used to run fine but I started getting the above message.

Please Login or Register  to view this content.

The colored rows are the ones that have the issue.
Im guessing it has something to do with the Cells reference.
Any assistance would be much appreciated.

Cheers

Hi Chinpunk

I tested your code and found out that the problem occurs when MyLastRow variable = 1, because then MyVar tries to refer to row No.... 0, which obviously doesn't exist.
I think this can be fixed using this:

Please Login or Register  to view this content.

Yes, Mordred indeed that line of code does not make sense.
I copied pasted from the above line thinking that its one cell down in the same column.
I ran the script again seems to be working.

Thank you for your time.

Hey Sbarro,

Thanks for your reply.
When i was hovering my mouse over the MyLastRow I saw the =1 value.
I will give your code a try in case that error shows up again.
By the way im using excel 2010 version.

Thank you for you time.