Copy and Paste to Hidden Tab

[dml5055]

Hi,

I'm trying to get my code to work by trying to copy from a visible tab into a hidden tab. Currently I have it able to function when the tabs are hidden, and i've been trying to get it to work, but i'm stuck. Maybe i can get some help here.

My code is below. I have a variable section because there are different sheets that will be hidden, and this is a way that i found works to get the variable tabs selected.

Please Login or Register  to view this content.

I would like to be able to keep the tabs hidden while it does the pasting if possible.

Thanks

[royUK]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

[dml5055]

sorry about the code part

Please Login or Register  to view this content.

[mudraker]

If you don't need to copy the cells formatting you could use this code

Please Login or Register  to view this content.

[romperstomper]

You could use:

Please Login or Register  to view this content.

[dml5055]

Thanks for the help. It works!