Is there a way of increasing Excels autofit by a specified height?

Why dont you try FormatRowHeight and specify the height..

OR

Select the rows (from the row header) and drag and adjust one row height
which will adjust the height of all rows selected

If this post helps click Yes
---------------
Jacob Skaria


"Neil Pearce" wrote:

Is there a way of increasing Excels autofit by a specified height?

Then it would NOT be AUTOfit
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Neil Pearce" wrote in message
...
Is there a way of increasing Excels autofit by a specified height?

Autofitting works fine to display all rows (1,000+), including those with
wrapped text on my worksheet.

However the boss has asked if I can increase the rows' height so that they
are spaced further apart and are therefore more legible.

The two options mentioned work fine, but are not efficient for the large
number of rows I have and the mixture of heights required for the wrapped
text cells.







"Jacob Skaria" wrote:

Why dont you try FormatRowHeight and specify the height..

OR

Select the rows (from the row header) and drag and adjust one row height
which will adjust the height of all rows selected

If this post helps click Yes
---------------
Jacob Skaria


"Neil Pearce" wrote:

Is there a way of increasing Excels autofit by a specified height?

Problem may be : is it possible to increase the automatic font size /
row height ratio ?
Daniel

Then it would NOT be AUTOfit

sub dorowht()
rows("12:22").rowheight=22
end sub


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Neil Pearce" wrote in message
...
Autofitting works fine to display all rows (1,000+), including those with
wrapped text on my worksheet.

However the boss has asked if I can increase the rows' height so that they
are spaced further apart and are therefore more legible.

The two options mentioned work fine, but are not efficient for the large
number of rows I have and the mixture of heights required for the wrapped
text cells.







"Jacob Skaria" wrote:

Why dont you try FormatRowHeight and specify the height..

OR

Select the rows (from the row header) and drag and adjust one row height
which will adjust the height of all rows selected

If this post helps click Yes
---------------
Jacob Skaria


"Neil Pearce" wrote:

Is there a way of increasing Excels autofit by a specified height?