July 22

Completing the Square aka The "Most" Squares Method

VBA

0  comments

Share this

Completing the Square aka The "Most" Squares Method

Now that I actually have some traffic to this blog, it’s probably time I started adding posts.

A while ago, I was wondering how to make the cells in Excel exactly square, like the squares on graph paper.  I came across this post from Mr. Excel.  I wasn’t in love with his solution because it requires users to first find their desired width by dragging a column, then writing it down (keep in mind it’s in pixels, so you might not have an easy round number), and then entering it into an input box.

So, without further ado, I present my solution that doesn’t require you to write anything down:

Private Sub AutoSize()

    Dim cels As Range
    Set cels = Me.Cells
 
    cels.ColumnWidth = 1  'Adjust me
    cels.RowHeight = cels(1, 1).width
 
    Set cels = Nothing

End Sub

To get different sized squares, simply adjust your ColumnWidth.  For further reading, checkout why widths in Excel are so tricky.

Loved this? Spread the word


About the Author

Jordan Goldmeier

Related posts

Make Your Excel Spreadsheet into a Bitmap Image With This Excel Magic Trick

Read More

Happy Holidays 2015

Read More

Enlarging Form Control Option Buttons

Read More

A method for quickly importing and working with CSV files (part 2)

Read More
{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

Subscribe to our newsletter now!

>