Is it possible to set a rows height in a formula in Excel?

Question

Is it possible to set a rows height in a formula in Excel?

For Microsoft Office 2003.

Answer 1

I don't think so. You would need to use VBA.

See RowHeight property is used to get the Height for an example.

Answer 2

You'd have to create a UDF to do it.

You could write it in a VBA module attached to the workbook. If you want it to affect the rows the formula is called on, use Application.Caller.RowHeight.

There may be some funky effects depending on how this formula is used. An odd request, but I've seen odder...

Answer 3

You have to use VBA. You'd have to write something into the worksheet_change event to read a particular cell then change the height based on the entry. No way to do it without coding.