Button macro to setup Columns And rows for sheet.

Hi

Can someone please guide me how i can set the below macro to do loop until it gets to row 450

Column A,B,E & F = 160 Pixel and Column C & D = 28 pixel
Row 1 = 27pixel
Row 2 = 92 pixel
Row 3 = 26 pixel
Row 4 = 3 Pixel

Please Login or Register  to view this content.

I want repeat the measurement of row 1 to 4 over and over until it get to row 450.

Once the rows are set merge cells A2:B2 and then E2:F2 move down 4 rows merge A6:B6 and then E6:F6 and repeat untl row 450.

Can someone show me how to repeat loop

Please see the attached file. I ave created button which user presses to setup sheet.

Help would be apricated.

I guess you could do it like this. By the way, merging cells is generally not advisable.

Please Login or Register  to view this content.