Using "On Error"

Hi all,
I have an unknown range of data to select. I came up with this code to do it.

Please Login or Register  to view this content.

I was wondering if this part of it is okay:

Please Login or Register  to view this content.

Doing this selects the unknown range and readies it for copy but if I do not use On Error, haha, I receive an error message. Is this acceptable by you gurus or is there another way I can do this?

Thanks TMShucks,
Your code worked well to select E3 to E15, but the end result to pick is all of the column that have data to the right of E, which turns out to be all the way to GS. The total is E3:E15,GS3:GS15. I am basically wanting to select data from 1961 Q1 to present Q (which is 2010 Q2). The update is that stupid. My code that I used selects the whole range but only works with the On Error statements.
I've attached a workbook so you can see roughly what I mean. Sheet1 has the data to find while Sheet2 is where the data is copied to.

Both ways worked folks, thank you very much.

Best Regards,

FYI, the reason for your error was that Select does not return a Range object, so you either needed to skip the assignment to the rng variable, or assign and then use

Please Login or Register  to view this content.

on a separate line.

Thanks romperstomper, I don't understand why VBA is that finicky though but it is what it is I guess.

It's a language and languages have rules. Otherwise they'd be gibberish.