Re: Use VBA to change row height or width??

  • Thread starter Thread starter Robert Crandal
  • Start date Start date
R

Robert Crandal

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?
 
Which headings are you referring to?

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

2. On the menu bar Tools>Options>View>Row 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.
 
Back
Top