Column widths & row heights

G

Guest

How do I make the column widths & row heights the same & = .25 inches?
I'm using Excel 2002.
 
G

Gord Dibben

Assuming 96 pixels per inch you could approximate but at different resolutions
your approximation can be off.

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

25.4 mm per inch

Ole Erlandson has code for setting row and column dimensions.

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


Gord Dibben MS Excel MVP

How do I make the column widths & row heights the same & = .25 inches?
I'm using Excel 2002.
Click to expand...

Gord Dibben MS Excel MVP
 
G

Guest

Gord, thank you for your prompt reply. I went to the web site you gave. But
I'm not sure how to use the information. I'm not very experienced. I've never
tried to write a Macro.
Tim
 

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

excel 2007 copy row heights 3
Copying excel worksheets to new worksheet 2
Heights 2
Copy row heights 1
Excel: copy grid, widths & heights down page: heights wrong! why? 1
How to copy & paste row heights and column widths to another page 2
rows and columns on worksheet 1
how do I link to another sheet in workbook? 12

Top