Row Height = ??
 

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

Row Height = ??
 

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