Hi All;
The spreadsheet that I am putting together, has 1000 rows of data in each Tab, but not all those 1000 rows are completed (have full rows of data)
What I am trying to do, is to select a cell that I know will have data in it all the way to the bottom of this set of data (but not the 1000 rows), and then select all the rows from the start to that row.
I will then get the Macro to copy this and paste into another worksheet.
At the moment I have this
However, this copies everything from the last row downwards, rather than everything from the first row (row 5) to the end row... what am I doing wrong?
In summary... I want to copy a certain amount of data, but cannot use End(x1down) on its own because that will select all 1000 rows.
Thanks
The spreadsheet that I am putting together, has 1000 rows of data in each Tab, but not all those 1000 rows are completed (have full rows of data)
What I am trying to do, is to select a cell that I know will have data in it all the way to the bottom of this set of data (but not the 1000 rows), and then select all the rows from the start to that row.
I will then get the Macro to copy this and paste into another worksheet.
At the moment I have this
Code:
Dim lLR As Long
lLR = Range("R5").End(xlDown).Row
Range("R" & Rows.Count & ":R" & lLR).EntireRow.Copy
However, this copies everything from the last row downwards, rather than everything from the first row (row 5) to the end row... what am I doing wrong?
In summary... I want to copy a certain amount of data, but cannot use End(x1down) on its own because that will select all 1000 rows.
Thanks