| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
set rowheight property
I need the syntax to set the active rowheight to 3
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
set rowheight property
With Worksheets("Sheet1").Rows(1)
.RowHeight = .3 End With "Ron5440" wrote in message ... I need the syntax to set the active rowheight to 3 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
set rowheight property
If you mean you want to set the RowHeight for the row that the ActiveCell is
in... ActiveCell.EntireRow.RowHeight = 3 -- Rick (MVP - Excel) "Ron5440" wrote in message ... I need the syntax to set the active rowheight to 3 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
set rowheight property
Rows(Selection.Row).RowHeight = 3
Or. Rows(ActiveCell.Row).RowHeight = 3 The row object has to be specified for the RowHeight property to work. "Ron5440" wrote in message ... I need the syntax to set the active rowheight to 3 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
set rowheight property
ActiveCell.entirerow.height = 3
-- HTH, Barb Reinhardt "Ron5440" wrote: I need the syntax to set the active rowheight to 3 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
set rowheight property
Perfect,
ThankYou RR "Barb Reinhardt" wrote: ActiveCell.entirerow.height = 3 -- HTH, Barb Reinhardt "Ron5440" wrote: I need the syntax to set the active rowheight to 3 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is RowHeight=0 the same as Hidden | Excel Discussion (Misc queries) | |||
| Format RowHeight question | Excel Programming | |||
| How to break the rowheight limit | Excel Programming | |||
| How can I find the rowheight and use it in a formula? | Excel Programming | |||
| Slow RowHeight behavior | Excel Programming | |||
Linear Mode
