Bob's code did change the height of row 1 for me.

You may not have noticed it since it was row 1--it looked like the top margin
had dropped down a bit for me.

If you put borders around row 1 (or give it a nice fill color), it'll be easier
to see.

And Bob's code could be made into an addin that does work with every workbook,
but this seems way to drastic (for even me). If I were you, I'd only add it to
the workbooks that needed that ability.

In fact, I'd be even more restrictive. I'd specify the names of the worksheets
that I want this to work on.

wrote:

thanks for your kind reply..
only column width changes and not row height?!!

is it possible to make this an addin so i can have this on every
workbook?

thanks

--

Dave Peterson