Grid Pattern

[JSW]

How would I go about creating and brick like grid pattern that I can use to design block layouts.
Thanks,
Jeff

 

[Burrgogi]

How would I go about creating and brick like grid pattern that I can use to design block layouts.
Thanks,
Jeff

Hi Jeff, welcome to the forum.

This is a MS Excel forum, not a LEGO forum. Please put your question in a form that we can all understand.

 

[JSW]

Hi Jeff, welcome to the forum.

This is a MS Excel forum, not a LEGO forum. Please put your question in a form that we can all understand.

I know this is an Excel forum. I simply would like to know how to set up the grid lines in a brick style pattern. Not sure how else to ask it.
Jeff

 

[jolivanes]

Change as required

Sub Maybe()
Dim i As Long, j As Long
For i = 1 To 26
    For j = 1 To 35 Step 2
        Sheets("Sheet1").Shapes.AddShape msoShapeRectangle, Columns(i).Left, Rows(j).Top, Columns(i).Width, Rows(j).Height
        Sheets("Sheet1").Shapes.AddShape msoShapeRectangle, Columns(i).Left + 0.5 * Columns(i).Width, Rows(j + 1).Top, Columns(i).Width, Rows(j).Height
    Next j
Next i
End Sub

 

[JSW]

Change as required

Sub Maybe()
Dim i As Long, j As Long
For i = 1 To 26
    For j = 1 To 35 Step 2
        Sheets("Sheet1").Shapes.AddShape msoShapeRectangle, Columns(i).Left, Rows(j).Top, Columns(i).Width, Rows(j).Height
        Sheets("Sheet1").Shapes.AddShape msoShapeRectangle, Columns(i).Left + 0.5 * Columns(i).Width, Rows(j + 1).Top, Columns(i).Width, Rows(j).Height
    Next j
Next i
End Sub

I am not sure how to do this. I’m not a power user and was thinking it would just be some settings to change
Jeff

 

[Fluff]

You cannot change the grid lines, so they overlap.

 

[dreid1011]

The best you might be able to do is going to be all manual. Use two column widths for 1 brick width and one row height for 1 brick height, then add borders/colors as you need for your layout?

I do this frequently, but I usually resize the cells to squares. ( I resized the columns to 40px below so the width is only 2x the height )

 

[jolivanes]

Re: "I am not sure how to do this"
Search for "How to install and run a macro in excel" or something similar.
Run the code supplied and come back with pertinent questions.

 

[Scott Huish]

I am not sure how to do this. I’m not a power user and was thinking it would just be some settings to change
Jeff

Hit Alt-F11
From the menu bar, click on Insert, then Module
Copy the code above and paste into the window.
Hit Alt-q to close the Visual Basic Editor

When back at the sheet, hit Alt-F8
Select the macro named Maybe and click Run

 

[JSW]

Thank you all for your help.
Jeff