Hi, I've combined a few bits of code from this board to come up with a macro that will combine a number of workbooks from the same directory into one master workbook. I just need help with selecting the range.
I am trying to select all used cells on the active sheet, except the column headings (Column Headings are rows 1-10, main data starts at row 11). At the moment my code for selecting the range is:
ws.Range("A11:E17").Copy
because in that worksheet there happend to be 7 rows of data. It will always be columns A:E, starting at row 11, but the number of rows will vary. Can somebody help me out with the code I need?
Thanks
Rich
I am trying to select all used cells on the active sheet, except the column headings (Column Headings are rows 1-10, main data starts at row 11). At the moment my code for selecting the range is:
ws.Range("A11:E17").Copy
because in that worksheet there happend to be 7 rows of data. It will always be columns A:E, starting at row 11, but the number of rows will vary. Can somebody help me out with the code I need?
Thanks
Rich