Select Rows to bottom of data

[JTL9161]

I have data that I add to daily. Where I added the new data I need to select the rows starting with the current cell and going to the bottom of the column (last row with data) There is a gap from the last row of data to a table about 10 rows below the last row of data so I only need to select the rows from the current cell to the bottom of the data but before the table.

I have this code:

Range(ActiveCell, ActiveCell.End(xlDown)).Select

but this only selects from the current cell to the bottom or column A. I need it to select the entire rows from current cell to last row with data.

Thank you for you help
James

 

[steve the fish]

You can use:

.EntireRow.Select

rather than just

.Select

 

[JTL9161]

Thanks!