Run-time error '9': Subscript out of range

[chergian]

Hi,

I have a simple code that copy values from one sheet to another, it really works but there is an error "Run-time Error 9: Subscript our of range".

This is the code:

Please Login or Register  to view this content.

Text in Red color makes the run-time error. I tripled check the name of every worksheets and the names specified and Data sheets, it's all perfectly correct.

Anyone help me this one? I attached the file for fast resolve.



Thanks....

[:) Sixthsense :)]

Change this line

Please Login or Register  to view this content.

To

Please Login or Register  to view this content.

[chergian]

Change this line

Please Login or Register  to view this content.

To

Please Login or Register  to view this content.

WOW! THANKS SO MUCH Sixthsense!