automaticaly increase the row spacing in xcel
 

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

automaticaly increase the row spacing in xcel
 

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

automaticaly increase the row spacing in xcel
 

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

automaticaly increase the row spacing in xcel
 

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

automaticaly increase the row spacing in xcel
 

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