row height IF functions

I have a spreadsheet where I am trying to use an "IF" function to change the height of the row.

Here's an example:

Cell A1 equals 0. I want the equation to make the row heignt = 0.25 if the number isn't >0

This is as far as I got and can't find the correct term for the row height.
=IF(A833>0,"rowheight=15",rowheight=0.25)

thanks

VBA? What's that?

the value that the IF is based on is = to a value on another page. The value on the other page is manually entered.

Use the IF function this way and you want to heighten rows with the word "SHIP' anywhere in column B
Use a column on the worksheet outside of your working area, Lets say you are using Columns A:M, use Colmmn Z
in Cell Z1 - Use the IF function to create a string (eg "abcdef")
Function is =if(B1="SHIP","abcdef","")
Drag this down Column Z as far as you want

Format all Column Z to "Vertical Alignment" and do not "Shrink to Fit" in cell formating.

When you get a hit on "SHIP" in Column B - all that Row will increase in height to accommodate the "abcdef" in column Z
Shorten or lengthen "abcdef" to change height
Multiple IF statements with diffent lenght strings will give different heights for different words
Changing font size in Z is also a control over row height.
Cheers from Oz
Ross

thanks, but ive switched to open office in the mean time and it's one of the little differences between the two. short story is it doesnt work in open office. thanks anyway

I'm sorry.. false alarm.. code works fine now. the code didn't run because there was fantom VBA projects still open.
Thank you very much again for the nice code.

[QUOTE=mikerickson;2211002]This UDF might help

I had a small problem when trying to add this to an existing module, in that the first two lines tried to attach themselves to the existing SUB that was in that module.

Once I pasted the statement into a NEW module this worked well, Thank you.

Also for the end users, I have used this formula in 24 rows in a model that I have been developing. In the worksheet I used a column to calculate the row number =Rows($R$1:$Rxx) where XX is the row that you are entering the formula into. (NOTE: I used Row R for my worksheet as it is outside of my print area, but you can use any column of course).

In Column S I set an if statement to test the columns that had the responses, i.e. in this case to sum those columns, so that if the columns had a response then the height to be set to 12.5 points, if blank 0 points. Rather than having the if as part of the function. You can use the IF statement either way.

In column T the RowHeight (this) function.

What I have found is that it does slow up the calculation aspect of the workbook a little, but is understandable. You could as an option change the calculation to a manual one rather than Automatic if it becomes a problem.