adjust row height

[still learning]

Hi
Sometimes it is difficult to adjust the height of a row with the mouse.
What code would I use to bring up an input box and change the height according to what I type in it?
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
I’ve been using the following but I want to be able to use random heights instead of a fixed number (20)
<o></o>

Sub Macro1()
Selection.RowHeight = 20
End Sub

<o></o>
<o></o>
Mike

 

[Gary McMaster]

If you right click on the row number and select "Row Height ..." an input box opens to allow you to key in a value. That's not good enough?

Gary

 

[AlphaFrog]

If you right-click on the row number, you can select from the pop-up menu Row Height. This will bring up a dialog where you can type in the height you want.

 

[still learning]

hi Gary McMaster, AlphaFrog

I didn't know that,

Thank you


Mike

 

[Gary McMaster]

Same for the column width. Just right click on the letter at the top of the column.

Gary