O
Old Red One
How do I set up a new worksheet overall 180 x 240 mm with cells 37 x 30 mm?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gord Dibben
A worksheet contains 65536 rows and 256 columns, no more no less.
Row heights are measured in points or pixels. There are 72 points to an inch
and "maybe" 96 pixels to the inch.
The number that appears in the Standard column width box is the average number
of digits 0-9 of the standard font that fit in a cell.
For an interesting and enlightening discussion on this subject see
http://snipurl.com/dzz8
If you want to use VBA to set height and width in mm.
Ole Erlandson has code for setting row and column dimensions in mm.
http://www.erlandsendata.no/english/index.php?d=envbawssetrowcol
You would then just hide the columns and rows you did not want to be viewed.
BTW 180 x 240 = 43200 sq. mm
37 x 30 = 1100 sq. mm per cell
43200 / 1100 = 38.9 cells
One or more of your parameters will have to be altered.
Perhaps if you describe what you are trying to achieve, some other method could
be devised.
Gord Dibben Excel MVP
Gord Dibben MS Excel MVP
Row heights are measured in points or pixels. There are 72 points to an inch
and "maybe" 96 pixels to the inch.
The number that appears in the Standard column width box is the average number
of digits 0-9 of the standard font that fit in a cell.
For an interesting and enlightening discussion on this subject see
http://snipurl.com/dzz8
If you want to use VBA to set height and width in mm.
Ole Erlandson has code for setting row and column dimensions in mm.
http://www.erlandsendata.no/english/index.php?d=envbawssetrowcol
You would then just hide the columns and rows you did not want to be viewed.
BTW 180 x 240 = 43200 sq. mm
37 x 30 = 1100 sq. mm per cell
43200 / 1100 = 38.9 cells
One or more of your parameters will have to be altered.
Perhaps if you describe what you are trying to achieve, some other method could
be devised.
Gord Dibben Excel MVP
How do I set up a new worksheet overall 180 x 240 mm with cells 37 x 30 mm?
Gord Dibben MS Excel MVP
O
Old Red One
Gord Dibben said:A worksheet contains 65536 rows and 256 columns, no more no less.
Row heights are measured in points or pixels. There are 72 points to an
inch
and "maybe" 96 pixels to the inch.
The number that appears in the Standard column width box is the average
number
of digits 0-9 of the standard font that fit in a cell.
For an interesting and enlightening discussion on this subject see
http://snipurl.com/dzz8
If you want to use VBA to set height and width in mm.
Ole Erlandson has code for setting row and column dimensions in mm.
http://www.erlandsendata.no/english/index.php?d=envbawssetrowcol
You would then just hide the columns and rows you did not want to be
viewed.
BTW 180 x 240 = 43200 sq. mm
37 x 30 = 1100 sq. mm per cell
43200 / 1100 = 38.9 cells
One or more of your parameters will have to be altered.
Perhaps if you describe what you are trying to achieve, some other method
could
be devised.
Gord Dibben Excel MVP
Gord Dibben MS Excel MVP
Thank you for your prompt response, and the references. I haven't yet read
them, but will.
I hoped to use EXCEL to lay out an album page for 15 stamps (Canadian
Jubilees, if you perchance are a collector); it seemed like a fun exercise,
a learning experience, and a challenge. So far I've constructed a
page-equivalent Worksheet of 84 rows 16.50 high, and five colums 33.71 wide.
As a newby I'm not familiar with VBA>
Again thanks for you help.