bvanscoy678
Member
Hi,
I received this code from a previous question and it worked perfect for another project.
I started a new project today and it only pulls the first value, exits the loop and then I get an error when it tries to save over the same file. It only copies one row, then exits the loop. I have checked the formatting of the column (2) I am using for the unique values and it is the same. In stepping through the code and looking at the variables, I don't see why it won't go past the first value. I can see it finds the correct last row.
I attached the sample workbook to help with my question. The 2nd Row, 2nd Column has a value of "E30A" . The code should look down to the last row and then copy all "E30A" rows to a new workbook (I think it actually deletes the other rows). This way I end up with a workbook for each unique value in the 2nd column.
I just used this code for another project and it worked perfect.
Thanks for any help, Brent
I received this code from a previous question and it worked perfect for another project.
I started a new project today and it only pulls the first value, exits the loop and then I get an error when it tries to save over the same file. It only copies one row, then exits the loop. I have checked the formatting of the column (2) I am using for the unique values and it is the same. In stepping through the code and looking at the variables, I don't see why it won't go past the first value. I can see it finds the correct last row.
I attached the sample workbook to help with my question. The 2nd Row, 2nd Column has a value of "E30A" . The code should look down to the last row and then copy all "E30A" rows to a new workbook (I think it actually deletes the other rows). This way I end up with a workbook for each unique value in the 2nd column.
I just used this code for another project and it worked perfect.
Thanks for any help, Brent
