Saving filename with content from a cell error

**bryanc2k** · 12-21-2010, 12:48 PM

Hi

I have a problem with a Autosave marco. the issue is that after copying and pasteing from one sheet to a new one all 22,663 lines are on the new sheet how ever when the sheet save's and closes nearl 10,000 of data are missing please can you advise.

Please Login or Register  to view this content.

Please note this marco is looped so generate customer files

**stnkynts** · 12-21-2010, 04:19 PM

Hello friend,

I tried to figure out what you have going on from your recorded macro. When I run it on a test workbook with some random data in sheet "CLP 5" It transfers over just fine to a new workbook. BTW I update your code to be.......less cumbersome. Here it is:

Please Login or Register  to view this content.

The only reason why you may not have the data there is you will get a pop up box asking if you want to save your data after the ActiveWindow.Close command. Click yes. Let me know how this works for you.