Copy paste code error

Dear all,
I am new to excel. I am stuck with this code, do not know why it is not working.any clue will be very helpful, thanks

Please Login or Register  to view this content.

shaukat,

First off, I'd recommend never using a keyword, like copy, as the name of a macro or function. Use something like CopyPaste or ImportData.

Second, the way you're declaring the range to copy is using the Cells without a sheet declaration, so they're defaulting to the active sheet. I know you have the sheet declaration outside the range, but within the range you don't have it so that is messing it up. Since you're already getting i and j, just use those directly instead:

Please Login or Register  to view this content.