Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Row height
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Row height
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 "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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help setting the worksheet header/Footer margins based on string height? | Excel Discussion (Misc queries) | |||
How to change default row height | Excel Discussion (Misc queries) | |||
set height of individual cells | Excel Worksheet Functions | |||
need to dbl row height without changing height of cell next to it | New Users to Excel | |||
Resizing row height to dynamically fit height of text box | Excel Discussion (Misc queries) |