Unable to create new Workbook and copy data into it

Try this code with the changes made.

Please Login or Register  to view this content.

Hey,

thanks for the suggestions. It does not show an error now and creates the new file, and saves it, and names it with the month, BUT...

It only copies Range A1:AG1...

Shouldn't this line:

Please Login or Register  to view this content.

Determine which row in column B is the last (data input to the macro varies, so it will never be exactly same number of rows) and apply the row number to the column AG? At least that was my intention, but now it only seems to copy A1 until AG1...


EDIT

I've figured it out. I think the variable "targetSheet1" wasn't used properly anymore (earlier in the code it's simply being defined as ActiveWorkbook, but since a new Workbook is created, it probably gets confusing as to which Workbook should be treated as Active... Just my guess though.).

In case anyone needed it, below I paste the code with my adjustments:

Please Login or Register  to view this content.

So thanks xlbiznes for the "New workbook" and "Set" prefix clarification!

That code will actually find the last cell in column B in the active sheet of the new workbook, to get the last row in column B in targetSheet1 you need to add a worksheet reference.

Please Login or Register  to view this content.