Macro Question

[abarone]

I am trying to figure out how to put a macro together to format an excel sheet to the following specs. I'm hoping someone can help me out here.

I need the macro to make all lines without any text set to 11 pixels in height
All lines with text to the following settings:

If the row has 1 line of text, it needs to be 18px in height
2 lines of text to 34px height
3 lines of text to 51px height
4 lines of text to 68px height
5 lines of text to 85px height


Is it possible to create some kind of macro to do this, as doing it maually every time is very tedious as I'm sure you can imagine!

 

[JackDanIce]

Not sure this can be done. A macro can evaluate if a cell has wrapped text or not but depending on the cell width will determine the number of lines it contains if the row is set to autofit, but that initself I don't think can output the number of text rows. Be interested to see if a solution is provided though.