Copy marked rows to new sheet

Great! It works as far as creating the new sheet, and naming it properly. However, now an error occurs when it tries to paste into the new sheet. Should I try to put this into option explicit? (esp. since the rest of the workbook this will be integrated into always has option explicit as well....) I'm not exactly sure how to do that...

Please Login or Register  to view this content.

the error now reads "application-defined or object-defined error" in the same place :-/

thanks for sticking with me

the error is still in the same place in the code. I had to change the sheet reference number to 1 in the beginning, becuase at first, it is the first sheet. the timeline sheet is inserted at the beginning, which changes the reference number of any sheet that will follow it...

Please Login or Register  to view this content.

i know... it's confusing.... in the beginning, the sheet with the information is sheet 1, then when the new sheet is added, it becomes second because the new sheet is first. I tried it out like this:

Please Login or Register  to view this content.

and it tried to copy onto the sheet where it copied FROM in the first place...

I'm trying to integrate this function into the main workbook now, and I'm running into problems with defined objects (I think).

This is the code as it stands:

Please Login or Register  to view this content.

I combined what I learned in this thread so far with some code that has been working throughout the rest of the workbook quite well (checking through the tabs for names it recognizes, copying the whole worksheet and pasting into the current sheet below the existing data). However, now I want it to sort for "x" before copying and pasting into the current sheet... ideas?

ah, silly mistake.... i guess that's what happens when you're just learning as you go along!