• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

paste columnwidths

H

HanSam

Member
Can anyone help me include a paste special column width for the following code

Code: 
On Error GoTo errorhandler
Range("A4:P" & Range("A4").End(xlDown).Row).AutoFilter Field:=5, Criteria1:=WeekNumber
'Range("A4:P" & Range("A4").End(xlDown).Row).AutoFilter Field:=4, Criteria1:="by CTL"
Range("A4:P" & Range("A4").End(xlDown).Row).Copy Workbooks(WeeklyName).Sheets("Sheet1").Cells(1, 1)
 
Hello Hansam

Am on mobile phone....Open new excel file...RECORD MACRO ...Copy some columns ...Paste some where with columwidths...And copy the recorded macro to amend your original code.
Let me know Any challenges...Happy to help you.
 
You must log in or register to reply here.
Back
Top