Use VBA to change row height or width??
 

Ok... the following code allows me to change the dimensions
of a row:

Rows(1).RowHeight = 30

This works fine, but now I noticed that Excel will not allow me
turn of my headings. When I click "View" and I try to uncheck
the "Headings" option, my headings will not turn off. What
happened here?



"Robert Crandal" wrote in message
...
I know how to change the width of a column by using the
following code:

Columns(1).ColumnWidth = 14

The problem is that I can't seem to find an equivalent
way to change the dimension of a row. Is there
an equivalent Rows() object that I can use in a similar manner?

thankx

Use VBA to change row height or width??
 

Which headings are you referring to?

1. On the menu bar ViewHeader and Footer refers to the page header and
footer that prints out, not the row and column headers.

2. On the menu bar ToolsOptionsViewRow and Column Headers refers to the
letters and numbers along the top and left edge of the worksheet. Checking
the box will show these characters, unchecking will take them away.

3. If you are referring to the header row(s) or column(s) that you created,
you will hide them to make them go away. They cannot be controlled from
with the View menu.


"Robert Crandal" wrote in message
...
Ok... the following code allows me to change the dimensions
of a row:

Rows(1).RowHeight = 30

This works fine, but now I noticed that Excel will not allow me
turn of my headings. When I click "View" and I try to uncheck
the "Headings" option, my headings will not turn off. What
happened here?



"Robert Crandal" wrote in message
...
I know how to change the width of a column by using the
following code:

Columns(1).ColumnWidth = 14

The problem is that I can't seem to find an equivalent
way to change the dimension of a row. Is there
an equivalent Rows() object that I can use in a similar manner?

thankx