Go Premium for a chance to win a PS4. Enter to Win

x
Solved

# Fixing a row height

Posted on 2014-01-16
Medium Priority
277 Views
Folks,
In a worksheet when activated I would like to set two row heights. For example, Row 3 and Row 4 would both be 105. This is a single event so I won't need a module.
0
Question by:Frank Freese
• 4

LVL 3

Expert Comment

ID: 39786664
In the activate event

Range("a1").height
0

Author Comment

ID: 39786744
got an error: Object required.
Here my code:
Range("A3").Height = 105
0

Author Comment

ID: 39786827
Solved ?
Here's the code
ActiveSheet.Row("3:4").Select
Selection.RowHeight=105

Any one see a problem here?
0

LVL 7

Accepted Solution

Steve earned 2000 total points
ID: 39786979
Dropped an "S" on rows.

ActiveSheet.Rows("3:4").Select
Selection.RowHeight=105
0

Author Comment

ID: 39787006
noticed that later
good catch though
thanks and enjoy the 500 points
0

Author Closing Comment

ID: 39787008
thanks you very much
0

## Featured Post

Question has a verified solution.

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

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…
This article describes a serious pitfall that can happen when deleting shapes using VBA.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
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 Month13 days, 8 hours left to enroll

#### 963 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.