How do I make the column widths & row heights the same & = .25 inches?
I'm using Excel 2002.
How do I make the column widths & row heights the same & = .25 inches?
I'm using Excel 2002.
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/...vbawssetrowcol
Gord Dibben MS Excel MVP
On Tue, 24 Jan 2006 09:10:02 -0800, Tim <Tim@discussions.microsoft.com> wrote:
>How do I make the column widths & row heights the same & = .25 inches?
>I'm using Excel 2002.
Gord Dibben MS Excel MVP
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
"Gord Dibben" wrote:
> 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/...vbawssetrowcol
>
>
> Gord Dibben MS Excel MVP
>
> On Tue, 24 Jan 2006 09:10:02 -0800, Tim <Tim@discussions.microsoft.com> wrote:
>
> >How do I make the column widths & row heights the same & = .25 inches?
> >I'm using Excel 2002.
>
> Gord Dibben MS Excel MVP
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks