Loop through all Sheets, PasteValues

**roasty_1** · 10-28-2008, 11:24 AM

Hi

Please could someone help with the code for looping through ALL the sheets in a workbook, copying ALL the cells and pasting the values?

Many thanks

Roasty

**royUK** · 10-28-2008, 11:36 AM

Courtesy of Aaron Blood

Please Login or Register  to view this content.

**roasty_1** · 10-28-2008, 11:42 AM

Thanks, I tried this but I kept getting an error:

Run-time error '1004';
Method 'Select' of object 'sheets' failed

why is this?

thanks

**royUK** · 10-28-2008, 11:55 AM

Have you hidden sheets?

**roasty_1** · 10-28-2008, 11:58 AM

Originally Posted by royUK

Have you hidden sheets?

Unhide all the sheets, code now works

Thanks

Roasty

**royUK** · 10-28-2008, 12:58 PM

Try this

Please Login or Register  to view this content.

Loop through all Sheets, PasteValues

LinkBack

Thread Tools

Rate This Thread

Display

Loop through all Sheets, PasteValues

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions