Row height

G

Guest

I'm using Excel 2003 and would like to control the row height to more than
..25 of an inch.

I've written a very easy macro

Sub changeheight()
With Sheets("Douglas scorecard_tourney")
Rows(17).RowHeight = 20.13
End With
End Sub

I haven't been able to see if this really worked because the printer is down
for some maintenance.

Can I do anything that would allow me to see that the macro actually worked?
If I look at the row height for row 17 - it will say twenty.
 
G

Guest

You should be able to see it, as well as verify it's height by moving to row
17 and selecting FORMAT/ROW/HEIGHT. Your printer being down for the count
will only impact your ability to print.
 
G

Guest

I appreciate your response - Either after changing the row height with the
macro or manualing keying it in - when I try validate that the numbers to the
right of the decimal point .13 are in the row height - they are gone - it
only will recognized .25, .5, or .75. (Is there a switch that I need to
adjust??)

And yes, I agree that the printer being down only affects the ability to
print
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top