Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Font used in Word won't come up in Excel - usg as data base-envel | Excel Discussion (Misc queries) | |||
Automation of Font Resizing | Excel Discussion (Misc queries) | |||
Default font for Comments | Excel Worksheet Functions | |||
Why is first font action v-e-r-y slow? | Excel Discussion (Misc queries) | |||
How to change the default font and size of "comments"? | Excel Discussion (Misc queries) |