Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 282
  • 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
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.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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