Hansen
10-24-2016, 02:31 AM
Hello everyone,
I want select rows, starting from a specific row (row number 8) to the last row, using the .end property.
Currently I am using the following approach:
dailyrecapwb.Sheets(1).Rows("8:" & Rows.Count).Copy
dailyrecapwb is an already opened workbook.
So far this code is working as expected and copying all rows beginning from row number 8 to the very last row.
In my table I have data from column A to column W.
Under this table there are some foot notes which are written in the column F to column Q, which I do not want to copy, but are currently being copied. This is why I want to select the rows starting at row 8 using the .end(xldown) property, as it should only copy the rows until the footnotes.
I tried using the following code:
dailyrecapwb.Sheets(1).Rows("8:" & Rows("8").End(xlDown)).Copy
Unfortunately this does not work, and returns the runtime error '13' "Type mismatch".
I know this is probably a stupid question, but since I am very new to VBA and tried looking for an answer for some time now, I figured I might just ask. Any help will be greatly appreciated!
I want select rows, starting from a specific row (row number 8) to the last row, using the .end property.
Currently I am using the following approach:
dailyrecapwb.Sheets(1).Rows("8:" & Rows.Count).Copy
dailyrecapwb is an already opened workbook.
So far this code is working as expected and copying all rows beginning from row number 8 to the very last row.
In my table I have data from column A to column W.
Under this table there are some foot notes which are written in the column F to column Q, which I do not want to copy, but are currently being copied. This is why I want to select the rows starting at row 8 using the .end(xldown) property, as it should only copy the rows until the footnotes.
I tried using the following code:
dailyrecapwb.Sheets(1).Rows("8:" & Rows("8").End(xlDown)).Copy
Unfortunately this does not work, and returns the runtime error '13' "Type mismatch".
I know this is probably a stupid question, but since I am very new to VBA and tried looking for an answer for some time now, I figured I might just ask. Any help will be greatly appreciated!