G
Guest
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?
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?