+ Reply to Thread
Results 1 to 5 of 5

why in H are Ht/Wd in TWO different units?

  1. #1
    Registered User
    Join Date
    07-25-2019
    Location
    Hilliard, OH, US
    MS-Off Ver
    Office 2010
    Posts
    23

    why in H are Ht/Wd in TWO different units?

    It makes it confusing as hell that height and width are shown in two different units, NEITHER of them seem to relate to the print size in centimeters, either... I'm pulling my hair out trying to align cells to print on a 80-label sheet.

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    16,615

    Re: why in H are Ht/Wd in TWO different units?

    You asked "why," and I have no idea why. Only Microsoft knows. But if your real question is "how," then here's how.

    Go to View > Page Layout view and you can set the width and height in inches. You can also change units to centimeters. Go to File > Options > Advanced > Display > select an option from the Ruler Units list.

  3. #3
    Registered User
    Join Date
    07-25-2019
    Location
    Hilliard, OH, US
    MS-Off Ver
    Office 2010
    Posts
    23

    Re: why in H are Ht/Wd in TWO different units?

    I complain too much... Shouldn't rely on tool tips anyhow, RowH() works..

    I tried that. Still it uses pixels and what I have called mystery unit that is 1.33 x pixels and not equivalent to set unit. I forget what .rowheight returns, or what .height sets. Wrote a short routine to set heights of does at intervals... What I really want, is to make clear concise color coded pictorial labels. Allignec to print on a 4z20 sheet. For example numbers. It would be in words, Arabic numeral, barcode, and "resistor" color code.

    I got ADD and depression.

  4. #4
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    16,615

    Re: why in H are Ht/Wd in TWO different units?

    I don't understand how you are trying to this. Your first post sounded like you were going through the user interface. Then your second post seems to refer to VBA, which is a whole different thing. This is very straightforward to set up in the Page Layout View.

    Here is how to lay out a page with 1/2" margins, 8.5" x 11" paper, 4 x 20 labels.

    inches.JPG

  5. #5
    Registered User
    Join Date
    07-25-2019
    Location
    Hilliard, OH, US
    MS-Off Ver
    Office 2010
    Posts
    23

    Re: why in H are Ht/Wd in TWO different units?

    OK - following up. I know how to set the width and height on WS and in VBA but the ratio from "mystery unit" to pixels varies from sheet to sheet AND from Horizontal and Vertical scales... it makes no sense. I didn't scale the proportion of the print output (not possible), I only set print scale to 60%. Margins T and L 0.25".

    What I want is to take a list of values, additional list of suffixes, and color cells based on those values to make a visual pattern... for example resistor color codes would be digit 1, 2, and len-1 K Bro R.... I am making a fx to make conditional formatting easier and flexible - values are on table and you can color adjacent cells without having the value in that cell... no CF fragmentation and easy copying for use across sheets and books... just need to get a array of say 5 x 7 cells per label.

    Any ideas?

+ 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. Convert units and units of measure
    By AntiPivotTable in forum Excel General
    Replies: 1
    Last Post: 10-21-2016, 07:22 PM
  2. [SOLVED] Formula to determine number of units at each location and status of units
    By Klimer in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 08-18-2016, 10:01 AM
  3. Trying to do conditional counting, units within units
    By Butcher1 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-17-2016, 01:01 PM
  4. E.G. 48 UNITS x $36.00
    By FVSURFER in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-18-2014, 07:20 AM
  5. How to Calculate the unites the sold over 70%!
    By Unseen in forum Excel General
    Replies: 5
    Last Post: 09-28-2012, 11:26 AM
  6. [SOLVED] Calculate the Bonus units according to the quantity of the units bought (Help)
    By mo_naf in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-15-2012, 05:51 PM
  7. units
    By Mindy in forum Excel General
    Replies: 3
    Last Post: 04-20-2005, 01:06 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