Row resize increments

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to set my row height to 49.81 but it only does increments of
..25....how do I change this?
 
Carl

That is as close as you get using column width. You do not change it.

Row heights are measured in points. There are 72 points to an inch.

If you want to use VBA to set height and width in mm....which you then convert
to inches.

49.81 points is .691806 inches.

..691806 inches is 17.57187 mm

Ole Erlandson has code for setting row and column dimensions in mm

http://www.erlandsendata.no/english/index.php?d=envbawssetrowcol

Gord Dibben Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Incrementing values 2
Automatically Increment numerically ordered rows 3
Formulas won't increment when dragging to adjacent cells? 3
How to increment a cell reference in a row 12
Increment Cell Reference using Indirect 0
Increment cell reference 1
row height 1
Auto-increment data source cell references when copying charts 2

Back
Top