Trouble with proper paste code line

[jim may]

Need to paste copied range to my summary sheet beginning at the activecell

.....
With Worksheets(i)
        .UsedRange.Copy
        'ThisWorkbook.Worksheets("Summary").ActiveCell Paste
 End With
.....

 

[Smitty]

To use ActiveCell you'll need to activate the sheet before you paste. Although I wouldn't advise this approach, because what if the active cell isn't where you think it is for some reason?

Is it the first empty cell in a range? If so, that's easy to target. If it needs to be activecell, then I'd probably try to identify it before the copy part, then you can direct reference it as a range variable.

HTH,

 

[jim may]

Smitty, Thanks for the suggestion.
Jim