Grid Boxes

G

Guest

I'm trying to create graph paper (one inch square boxes) using excel.
However, excel uses pixels to change row and column widths. I've got real
close but when i print the graph sheets and measure with a ruler its not a
one inch square box. Any ideas how to approach this or how to make one inch
square cells? thanks inadvance.
 
A

Ardus Petus

With font Arial 10 (default)

with yourRange
.RowHeight=72
.ColumnWidth=13
end with

produces 72x72 points squares.

HTH
 

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

Top