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

Fixing a row height

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
Frank Freese
Asked:
Frank Freese
  • 4
1 Solution
 
fredvr666Commented:
In the activate event

Range("a1").height
0
 
Frank FreeseAuthor Commented:
got an error: Object required.
Here my code:
Range("A3").Height = 105
0
 
Frank FreeseAuthor Commented:
Solved ?
Here's the code
ActiveSheet.Row("3:4").Select
Selection.RowHeight=105

Any one see a problem here?
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
SteveCommented:
Dropped an "S" on rows.

ActiveSheet.Rows("3:4").Select
Selection.RowHeight=105
0
 
Frank FreeseAuthor Commented:
noticed that later
good catch though
thanks and enjoy the 500 points
0
 
Frank FreeseAuthor Commented:
thanks you very much
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.

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