Loop worksheets Copy range and Paste in LastUsedCell in first worksheet, delete Worksheet

**Simone Fick** · 07-24-2017, 09:33 AM

Hi,

I have a loop to copy a data range (find last row for data because it always differs) from worksheet 2, paste it in the "Summary" worksheet (next empty row) and delete ws2, then go on to worksheet 3 and repeat.
I'm finding an error on the paste line :" Method 'Range' of Object '_Worksheet' failed.

This is the current code

Please Login or Register  to view this content.

**davesexcel** · 07-24-2017, 09:40 AM

A couple of things,

Please Login or Register  to view this content.

**Simone Fick** · 07-24-2017, 10:01 AM

Excellent, thanks!!

Loop worksheets Copy range and Paste in LastUsedCell in first worksheet, delete Worksheet

LinkBack

Thread Tools

Rate This Thread

Display

Loop worksheets Copy range and Paste in LastUsedCell in first worksheet, delete Worksheet

Re: Loop worksheets Copy range and Paste in LastUsedCell in first worksheet, delete Worksh

Re: Loop worksheets Copy range and Paste in LastUsedCell in first worksheet, delete Worksh

Thread Information

Users Browsing this Thread

Similar Threads

Copy and Paste from Workbooks to Worksheet Loop

VBA Match Cell Range to Worksheet Name and copy/paste to respective worksheet

[SOLVED] VBA Loop through each worksheet except two and then copy paste

Match Cell Value to Worksheet Name Then Copy/ Paste Range to Worksheet

Loop through Worksheets find Value & Paste in another Worksheet, SUM values from Column

Copy Range from Worksheet 2, Paste to Next Empty Row Worksheet 1

Loop to copy rows and paste into worksheet

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions