Can I "Paste Special w/values & number formatting" AND "keep source column width"

[John.McLaughlin]

Hello,

I am trying to create a simple macro to copy a range to {Workbooks.Add} then {ActiveSheet.Paste}.

Can I combine the Paste special w/values and number formats AND the keep source column widths together?

Thank you in advance.

JM

 

[John.McLaughlin]

Very nice tip Jerry, your suggestion cleaned up nicely. I try to take the time to use less words when writing folks too.

SD is the place for me. I have family in el Casa de Plenty. I could even be homeless with your great weather. A solar laptop charger and a wifi connection, come and get me rays

Many thanks my friend, raising my coffee cup to you, have a great week!