cell format changes

ricksimm

Board Regular
Joined
Apr 28, 2005
Messages
188
I have a cell formatted as General and shrink-to-fit. When I copy text that is too long for the cell to the cell, the format changes to wrap text. Can I use vb to stop this from happening?
 

Some videos you may like

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Sprucy

Board Regular
Joined
Oct 31, 2005
Messages
92
Hey ricksimm,

Copy
Paste Special > Values

Seems to work...

Cheers,
Sprucy
 

Watch MrExcel Video

Forum statistics

Threads
1,118,081
Messages
5,570,089
Members
412,310
Latest member
mark884
Top