• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 192
  • Last Modified:

Changing row height of several rows

I'm trying to change the row height of rows 1 to 5.

Rows(1:5).rowheight = 34    This doesn't work BTW.


How about autofitting rows 1 through 5?

Rows(1:5).rowheight.autofit
0
brothertruffle880
Asked:
brothertruffle880
1 Solution
 
MichaelBusiness AnalystCommented:
Try:
Rows("1:5").RowHeight = 34
Rows("1:5").EntireRow.AutoFit

Open in new window


Joop
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now