Solved

# Changing row height of several rows

Posted on 2013-11-18
Medium Priority
189 Views
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
Question by:brothertruffle880
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
1 Comment

LVL 6

Accepted Solution

Michael earned 2000 total points
ID: 39657215
Try:
``````Rows("1:5").RowHeight = 34
Rows("1:5").EntireRow.AutoFit
``````

Joop
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
###### Suggested Courses
Course of the Month11 days, 14 hours left to enroll