Selecting data down to last row.

**CJPHX** · 05-25-2010, 03:01 PM

I am currently compiling multiple worksheets with similar data into one so it is organized. I have a macro that finds the worksheet name I am looking for and copys the range I need. For Example: A2:D25. However if the data goes past row 25 I don't get it all if it goes shorter I have empty cells. How Do I get it to select until the last row of data?

**snb** · 05-25-2010, 03:08 PM

Use sheets1.Usedrange

**EK1** · 05-25-2010, 03:08 PM

Try this for finding the last row of data:

Please Login or Register  to view this content.

Make your range as:

Please Login or Register  to view this content.

I'm assuming Z as your last column....change as required

**royUK** · 05-25-2010, 03:10 PM

You shouldn't need to select,it will slow the process

**Leith Ross** · 05-25-2010, 03:28 PM

Hello CJPHX,

It depends on how you define your last row. If the last row is the last cell in a column that has a visible data then EK1's code is what you should use. If you are defining the last row as any cell with a border, colored background, or formula then use snb's code.