Stanley,

ActiveSheet.UsedRange.RowHeight = ActiveSheet.StandardHeight + 2

Jim Cone
San Francisco, USA


"Stanley" wrote in message
...
I want to increase the row spacing from the standard spacing which is
contingent on the lines of text to the standard plus a line or 2 in order to
have more white space between the items in each row. We do it manualy now how
do you do it automaticaly