cell/column/row size??

[L.S.]

Excel 2k, winxp

Would like to set up a spreadsheet with the columns and rows all the same
size and with the measurements in " instead of characters, pixels and/or
points.
What I'm actually trying to do is set up each column as 1.25" and row .50".

Is this possible without "trial and error"?

 

[Gord Dibben]

You will have to use VBA to get those exact measurements.

Ole Erlandson has code for setting row and column dimensions in millimeters.

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

25.4 mm to the inch


Gord Dibben Excel MVP

 

[L.S.]

Thanks.

You will have to use VBA to get those exact measurements.

Ole Erlandson has code for setting row and column dimensions in
millimeters.

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

25.4 mm to the inch


Gord Dibben Excel MVP