Copying worksheet with VBA

[RicksAtWork]

Whenever I copy a range from a worksheet to another worksheet, with VBA, the columns widths change.

Is it possible to stop this?

Range(deskResearchRangeString).Select
Selection.Copy

'Paste To new Sheet
Windows(ExportWorkSheetFilename).Activate
countryWorkSheet.Paste

 

[SkipVought]

You can do this in another statement, if your copy the COLUMNS and Paste Special - Formats.

Skip,

_{[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine!}

 

[RicksAtWork]

Not sure I understand!!

Can you give me an example?

 

[SkipVought]

Select the SOURCE columns of interest.

COPY

Select the DESTINATION columns of interest.

Edit/Paste Special- Formats.

Skip,

_{[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine!}