square

  1. M

    How to find radius of a circle needed to contain a certain number of squares of a given size

    Hello, I stumbled across the following code somewhere... the code uses the radius of a circle and the dimension of a square to tell you how many squares you can fit inside the circle and then draws the circle and array of squares in the spreadsheet. I really need to do the opposite. I want to...
  2. T

    Sum squares

    Hi! I want to make a code in vba in wich the user selects a range of only one row and as many columns as he wants. In the range the user selects, the code must sum the square of the first number, then the third, the fifth and so on (2 by 2)... The result of this code has to appear exactly below...
  3. T

    Trying to convert 2 cells from inches to inches and feet. Then need to multiply them together to get a square footage. All in one cell

    Hello All, Here's the issue i'm having. In cell A3 i have 66". I take the formula =INT(A3/12) & " ft. " & MOD(A3,12) & " in." which gives me 5ft. 6in. - PERFECT Now I get lost. Lets say C3 is 66" as well. i need that to convert to (5ft. 6in.), then I need to multiply A3 and C3 together to get...
  4. G

    set shape size from cell data

    I would like to make a macro which inserts a square shape with the dimensions earned from a cell. For example A1 says 5 and B1 says 2. So I'd like to set square height to A1 so it will be 5. and widht to B1 so it will be 2. So whenever I change values in A1 and B2 and rerun the macro it would...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top