Thread: Row height
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Brad Brad is offline
external usenet poster
 
Posts: 846
Default Row height

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

"Kevin B" wrote:

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.
--
Kevin Backmann


"Brad" wrote:

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.