Copy and paste in dynamic range

[mangeshp4]

Hi All

I am trying to create a code which copy from one workbook & paste it in another workbook where criteria matches

I got stuck in following line . ERR : Run time error 1004 : Method Range of object worksheet failed.

Please Login or Register  to view this content.

Entire code is pasted below.

Please Login or Register  to view this content.

[sktneer]

Either you use

Please Login or Register  to view this content.

OR

Please Login or Register  to view this content.

[mangeshp4]

Thanks !! that certainly helps.

[sktneer]

You're welcome.

If that takes care of your original question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.