Results 1 to 3 of 3

How to make a cell a perfect square?

This is a discussion on How to make a cell a perfect square? within the Excel Questions forums, part of the Question Forums category; I know, must be an odd question but I'm making a chart and would like to have the length and ...

  1. #1
    Board Regular
    Join Date
    Dec 2003
    Posts
    91

    Default How to make a cell a perfect square?

    I know, must be an odd question but I'm making a chart and would like to have the length and width the same size. How exactly does one go about doing that?

    Thx

  2. #2
    Board Regular texasalynn's Avatar
    Join Date
    May 2002
    Location
    Houston, TX
    Posts
    8,308

    Default Re: How to make a cell a perfect square?


  3. #3
    Board Regular jim may's Avatar
    Join Date
    Jul 2004
    Location
    Roanoke, VA
    Posts
    6,329

    Default Re: How to make a cell a perfect square?

    A bit CRUDE, but here's a way...

    Code:
    Sub Tester()  ' YOU MUST SELECT THE DESIRED RANGE BEFORE RUNNING THIS MACRO
    Mult = 5.42   ' the multiple to equal rowheight to column width
    'Selection.RowHeight = (Cells.ColumnWidth + 0) * Mult   ' to do complete sheet
    Selection.RowHeight = (Selection.ColumnWidth + 0) * Mult  'to do only selected range
    End Sub
    To display your spreadsheet data use either MrExcel HTML Maker or Excel Jeanie

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com