How can I make my row height exactly 21.4?

M

Monty

Each time I try to make my row height an exact size it rounds to the nearest
..25. I am using Microsoft Office XP and I have all of the latest updates.
 
R

rpw

Each .25 is equal to 1 pixel on the display. And the display cannot go less
than 1 pixel. So you won't be able to get a row height other than in .25
increments.
 
G

Gord Dibben

Monty

You cannot change this default behaviour.

Why do you need 21.4 points?

Perhaps there is something else can be done to approximate if we knew why.

Like set to millimeters or inches via VBA although I doubt you'll get closer
than 1/72 of an inch which is the difference between 21.4 and 21.5

Not seen by the naked or clothes eye, I would submit.

Gord Dibben Excel MVP
 
Top