Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hey folks! I want to print out tabs for Case Logic CD storage sleeves.
I use these sleeves to store my collection of live shows. I plan to use Excel, since my list is in this format and I can C&P the info I want on the tabs. My question is about adjusting the height of the rows (and column width) to fit the slot they go in. Are the height/width numbers in inches, milimeters, or something different? If so, is there a way to convert this number to inches or milimeters? I couldn't find anything regarding this. Thanks for your help! Rich |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
You might have better luck using mail merge in Word with Excel as the
source. You will have better control there. Width is in the width of the default font for the character zero. Height is in points I believe. Check Excel VBA help for rowheight and columnwidth Returns the height of all the rows in the range specified, measured in points. << One unit of column width is equal to the width of one character in the Normal style. For proportional fonts, the width of the character 0 (zero) is used. << Settings can not be continuously set - there are only discrete increment limitations in my experience. Excel is not a good platform for page layout type operations. -- Regards, Tom Ogilvy Rich G wrote in message m... Hey folks! I want to print out tabs for Case Logic CD storage sleeves. I use these sleeves to store my collection of live shows. I plan to use Excel, since my list is in this format and I can C&P the info I want on the tabs. My question is about adjusting the height of the rows (and column width) to fit the slot they go in. Are the height/width numbers in inches, milimeters, or something different? If so, is there a way to convert this number to inches or milimeters? I couldn't find anything regarding this. Thanks for your help! Rich |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Set a minimum row height a the same time with autofit row height | New Users to Excel | |||
Row Height stopped growing and Auot-Fit Row Height does not work | Excel Discussion (Misc queries) | |||
the row height should be excatly the height of the data | Excel Discussion (Misc queries) | |||
Resizing row height to dynamically fit height of text box | Excel Discussion (Misc queries) | |||
resize row height and column height | Setting up and Configuration of Excel |