Column Width

[mdasifiqbal]

Dear Friends

I have attached an Macro enable Excel file which filters unique customer name create a new xls file and copy / paste the special cells selected. the issue is the column width in the new xls created it is not of the size of the cell copied, how do i have the cells width same as the one from where the data is copied.

Thanks and regards

Md Asif Iqbal1969619696

[mana]

>Else
> Workbooks.Add
> ActiveWorkbook.SaveAs Pth & d & ".xlsx"



Else
Source.Copy
Workbooks.Add
ActiveSheet.PasteSpecial xlPasteColumnWidths
ActiveWorkbook.SaveAs Pth & d & ".xlsx"

[mdasifiqbal]

Thanks a lot Mana it working but only for column A.

[mana]

>Source.Copy

Source.resize(,12).copy

[mdasifiqbal]

Thanks Mana its working Great.