10$ For VBA Code Split Data To Multiple Workbook Based On Unique Values In A Column

[jamilm]

thank you very much. i do not even know your name. but i i guess that our messages have crossed before in mrexcel forums.

so, please give pm me your paypal ID so that i send you 10 bucks.

also looking forward for solution to my outlook project in the other thread.

The reason why the modified code worked is because I reduced the range of cells to just the used range of the sheet. So it's your available resources that's cause the trouble. Having said that, I should have only used the used range instead of the entire cells.

To add a name to the sheet, just add the below line, right after the workbook is added

wb.Sheets(1).Name = "NameOfSheetHere"

https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA

https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA