LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rayo K
 
Posts: n/a
Default How wide is a font?

I am trying to make a field of square worksheet cells. I have reviewed the
message board and found the VBA code to make a certian cell be square, but I
want to make thousands of squares, and I want to leave the default height

Right now I can make one cell square, read it's width and height, calculate
the ratio, figure out what width equates to 12.75 height, select all columns,
and change the width...

....but I want to know how to determine the column width by simply
multiplying by digits/inch (i.e. the default font width). How do I do that?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Font used in Word won't come up in Excel - usg as data base-envel SLJackson Excel Discussion (Misc queries) 1 September 10th 05 12:31 AM
Automation of Font Resizing Mike Excel Discussion (Misc queries) 0 August 29th 05 09:50 PM
Default font for Comments Debra Dalgleish Excel Worksheet Functions 0 August 25th 05 11:55 PM
Why is first font action v-e-r-y slow? [email protected] Excel Discussion (Misc queries) 2 March 11th 05 08:01 AM
How to change the default font and size of "comments"? ClayMcQ Excel Discussion (Misc queries) 1 January 7th 05 11:43 PM


All times are GMT +1. The time now is 04:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"