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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use VBA to change row height or width?? 3
Auto-Calculate price based on width x height 0
Row Height -- Slows VBA 7
Row height & Column width locked? 1
Automatically Setting Row Height with Merged Cells 3
Column width & Row Height changing using macro/vb 2
Adjusting row heights and column widths to align with another sheet 1
Control Row Height 5

Back
Top