+ Reply to Thread
Results 1 to 3 of 3

Precice ColumnWidth in centimeters

  1. #1
    Registered User
    Join Date
    02-07-2021
    Location
    France
    MS-Off Ver
    365
    Posts
    2

    Precice ColumnWidth in centimeters

    Hello.

    This is my first post. Sorry to be able to speak english only like a french.

    The purpose of this little Work done today was first to be able to print a sort of ruler in centimeters.
    Then I wrote this more explicit example of 4 different sizes columns.
    I tried to write all explanations in comments.

    Please Login or Register  to view this content.
    Last edited by titof_fr; 02-08-2021 at 04:04 PM. Reason: spelling

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,053

    Re: Preciced ColumnWidth in centimeters

    I have a feeling that you wont be able to set columns to exact cm widths, for a few reasons...
    1. column widths are set to pixels, with the default width 8.43 characters, which corresponds to 64 pixels
    2. the screen resolution and aspect ration may also throw things off
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    02-07-2021
    Location
    France
    MS-Off Ver
    365
    Posts
    2

    Re: Preciced ColumnWidth in centimeters

    Hi.
    You are surely right with screen representation.
    The purpuse was to be able to manage columns sizes in centimeters, and have a full width set to an exact width on paper (with dPrinterCorrecCoef),
    even if inside columns proportions don't have a hundredth of a millimeter precision.
    My printed ruler is what I expect.
    JC

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. ColumnWidth Problem
    By Jarod9856 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-12-2015, 01:53 PM
  2. ColumnWidth vs Column.Width
    By danex in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-24-2013, 10:21 AM
  3. Capture Activecell's ColumnWidth
    By srinivas1104 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-13-2011, 01:33 PM
  4. Cannot set ColumnWidth past column 148
    By MNTye in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-07-2006, 08:50 AM
  5. [SOLVED] Convert cubic centimeters to fluid ounces and cubic centimeters
    By OcalaElaine in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-14-2006, 01:50 PM
  6. [SOLVED] convert cubic centimeters to fluid ounces and cubic centimeters
    By OcalaElaine in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-13-2006, 05:10 PM

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