+ Reply to Thread
Results 1 to 3 of 3

Column widths & row heights

Hybrid View

  1. #1
    Tim
    Guest

    Column widths & row heights

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

  2. #2
    Gord Dibben
    Guest

    Re: Column widths & row heights

    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

  3. #3
    Tim
    Guest

    Re: Column widths & row heights

    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
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1