AutoResize macro?

[AussieRed]

Hey everybody,

I have learnt so much from this site so I would just like to start out by saying thanks alot for all your help.

Now, my question. I have a macro written that copies a cell and pastes it into a new worksheet. Is there code that will automatically resize the cell in the new worksheet to fit the text that I am pasting?

Cheers.

 

[Legacy 98055]

Hi Red.
Choose one or both depending on what type of fit you need.
<pre>
Range("A1").Columns.AutoFit
Range("A1").Rows.AutoFit

</pre>
Tom

 

[AussieRed]

Thanks Tom.