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

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

Activesheet.UsedRange.EntireRow.RowHeight = 3 * 12.75

If you mean you have workwrap and multiple lines of text in the cell (each
row would have a different Height.

Sub BB()
For i = 1 To 4
ht = Cells(i, 1).EntireRow.RowHeight
Cells(i, 1).EntireRow.RowHeight = ht + 2 * 12.75
Next

End Sub

possibly




--
Regards,
Tom Ogilvy


"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

Tom's reply understood the question how do i "program" or change my spread
sheets to try his solution?

"Stanley" wrote:

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

a simple hack:
insert a column (or use an empty one :)
set fontsize a bit larger than standard text (16?)

et voila.. higher rows..

using format/row/autofit.. wont 'destroy' your layout.


PS: setting font size does alter usedrange thus filesize
so keep your column close to the data and dont use IV.


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Stanley wrote :

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