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.
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.
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.
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.
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
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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks