copy and pasting in hidden sheets

**maacmaac** · 06-04-2008, 10:06 AM

I have a spreadsheet with multiple sheets and two of these sheets I need to hide (sheet1 and sheet2). I have a macro that copies data from sheet1 to sheet2. If I hide the sheets, I get a runtime error. How can I simplify my code so I don't have to include in my code commands to unhide and hide my sheets? Thanks

Please Login or Register  to view this content.

**StephenR** · 06-04-2008, 10:18 AM

You don't need to select anything which should get round your problem:

Please Login or Register  to view this content.

**Shijesh Kumar** · 06-04-2008, 10:55 AM

Here is the code which copies the column A data from sheet1 to sheet2...

Please Login or Register  to view this content.

**royUK** · 06-04-2008, 11:08 AM

Just define the range & copy it to the destination sheet, no need for a loop.

Please Login or Register  to view this content.

**maacmaac** · 06-04-2008, 11:14 AM

Thanks for the code. One more question. I just realized that when I do the paste, I am using a paste special and pasting values only. How do incorporate this into the new code?

Please Login or Register  to view this content.

**StephenR** · 06-04-2008, 11:22 AM

In my code:

Please Login or Register  to view this content.

Similar for Roy's code.

**royUK** · 06-04-2008, 11:26 AM

Maybe

Please Login or Register  to view this content.

**StephenR** · 06-04-2008, 11:34 AM

Extrapolating from Roy's thought, this should work too:

Please Login or Register  to view this content.

copy and pasting in hidden sheets

LinkBack

Thread Tools

Rate This Thread

Display

copy and pasting in hidden sheets

Thread Information

Users Browsing this Thread

Similar Threads

Copy & Pasting Conditional Formats (Excel 07)

Copy sheets and remove named range

Pasting into password protected sheets.

copy and pasting formulas!!

help with copy sheets of data

Bookmarks

Bookmarks

Posting Permissions