LastRow and Multiple Ranges

I am using the following line of code in a bunch of different spreadsheets.

Please Login or Register  to view this content.

The current whole code I am using it in is as follows:

Please Login or Register  to view this content.

What I tried to do was the following:

Please Login or Register  to view this content.

The above did not work.

Since the main code is copying from one sheet to another, I was hoping that either the code i changed would work and if not how do I code the second copy/paste command to the book created by the Workbook.Add line. K1:L would need to be pasted into H:L on in the "existing" new book.

I could also edit the existing code to just delete the rows I don't need but i was curious to know if multiple ranges could be selected

Did you try without a macro? I get the following: The command cannot be used on multiple selections.
You can't copy non-continuous selections. You'd need to instead use:

Please Login or Register  to view this content.

Or, if easier, you could just copy the entire sheet into a new workbook and delete everything you don't need off of it. See Worksheets().Copy

Like so:

Please Login or Register  to view this content.

Hmm, thought I tried that but must've got something wrong. Thanks for the correction JB.

Deleting original post in response to davegugg.

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.