VBA to autofit row height with a minimum

Hi,

I have a range named "rngOrders" on an Excel 2003 worksheet. I'm looking for a VBA macro that will set the row heights of the range to autofit (for rows/cells with wrapped text) and also set a minimum row height of 19.5 points for all rows. Any suggestions?

Cheers,

Please Login or Register  to view this content.

Hi shg,

Thanks for your help.

That code gives me an error:

Please Login or Register  to view this content.

???

Please Login or Register  to view this content.

This post was made in error, please delete.

Okay, this works:

Please Login or Register  to view this content.

Thanks!