Selecting range question

[MaddyG]

There's a ton of examples of how to find the last row with data out there, and I'm sure there's a simple solution I'm just not getting, but here's my dilemma:

In column "A" I need to select the 2nd row, find the last row with data in column A, then move over to column "E", which may or may not have data in it.
So the range I need to copy will always extend A to E, but to number of rows will be determined by the last row with data in column A.

Have attached simple spreadsheet if that helps.

thanks

[AlphaFrog]

Try this...

Range("A2", Range("A" & Rows.Count).End(xlUp)).Resize(, 5).Copy

[MaddyG]

Perfect - thanks!

[MaddyG]

as a follow-up to this question, I'm trying to copy that range into another workbook using the following code:

Please Login or Register  to view this content.

Is there anything wrong with this? It seems most examples i've found are declaring variables and the code to copy from one workbook to another is about 3 times as long. Is that necessary here?

[AlphaFrog]

You should specify the workbook and worksheet for referencing the last used cell in column A

Please Login or Register  to view this content.

or just use a With-End With code block.

Please Login or Register  to view this content.

And use an Exit Sub to prevent displaying the MsgBox when there is no error.

[MaddyG]

Thanks again - tried both and both resulted in a "subscript out of range" error.

[MaddyG]

it worked perfect. The sheet name had a space at the end of it I was unaware of.

thanks again!