Solved

Fixing a row height

Posted on 2014-01-16
6
229 Views
Last Modified: 2014-01-16
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
Comment
Question by:Frank Freese
  • 4
6 Comments
 
LVL 3

Expert Comment

by:fredvr666
Comment Utility
In the activate event

Range("a1").height
0
 

Author Comment

by:Frank Freese
Comment Utility
got an error: Object required.
Here my code:
Range("A3").Height = 105
0
 

Author Comment

by:Frank Freese
Comment Utility
Solved ?
Here's the code
ActiveSheet.Row("3:4").Select
Selection.RowHeight=105

Any one see a problem here?
0
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

 
LVL 7

Accepted Solution

by:
Steve earned 500 total points
Comment Utility
Dropped an "S" on rows.

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

Author Comment

by:Frank Freese
Comment Utility
noticed that later
good catch though
thanks and enjoy the 500 points
0
 

Author Closing Comment

by:Frank Freese
Comment Utility
thanks you very much
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

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

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

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now