vba-changelog Run-time error Description

General information Visual Basic run-time errors seem to appear randomly without any particular patterns.

Description #1 (img 1 and 2) One of the errors appeared when I cut information from one cell to another.

Description #2 (img 3 and 4) The Spread sheet was saved and reopened. An error appeared when an attempt was made to change information in one of the cells (“Number of Stores”).

Apr 25 '13 09:04 DmitryRandar

As you can see in the comments in my code you have somehow managed to stumble upon the elusive error I couldn't consistently reproduce. Both errors you describe and both sets of screenshots are actually the same issue.

Apr 25 '13 12:04 steveno

Thanks for your response Steven. I see now... Have I understood correctly. The problem is known to you and you are not sure of its origin?

Regards, Dmitry

Apr 25 '13 12:04 DmitryRandar

@DmitryRandar exactly

Apr 25 '13 20:04 steveno

OK, no problem at all! Many thanks for your response. If I manage to find a way to fix it, I will let you know. All the best and thank you for the free code and a great script idea.

Apr 26 '13 07:04 DmitryRandar