Christyr;344662 Wrote:
How can I keep row height from changing when I perform a sort? When I
sort, I
lose sight of some of my information in my cells and then have to
resize my
row height when I re-sort.
Thank you for your help.Well without VBA you could simply click the "Home" square (next to A and
above 1 top left of your worksheet) then press and hold Alt then press
O, R & A one after the other whilst holding Alt, this will autofit your
rows, or using the mouse, click the home square, Format, Rows, Autofit.


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=96428