How to select 3 cells, transpose, loop to select next 3 cells.

**Hood** · 03-02-2017, 01:53 PM

I want to create a macro that will search the cells in column B, select the first set of three values in column B and transpose it in Column D1. Then select the next three values in column B and transpose in Column D2., Continue until the first blank cell in Column B. I have tried to attach a photo as well
I appreciate any help/advice. Thanks!

Capture.JPG

**walruseggman** · 03-02-2017, 02:03 PM

Please Login or Register  to view this content.

**Hood** · 03-02-2017, 02:07 PM

Thanks very much for the help!

How to select 3 cells, transpose, loop to select next 3 cells.

LinkBack

Thread Tools

Rate This Thread

Display

How to select 3 cells, transpose, loop to select next 3 cells.

Re: How to select 3 cells, transpose, loop to select next 3 cells.

Re: How to select 3 cells, transpose, loop to select next 3 cells.

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Help with loop to select range of cells that meet criteria

excel using VBA how to select specefic cells based on their values and copy these cells in

Need to loop to a ceretain value then select a range of cells

[SOLVED] select cells through loop

Formatting cells other than select-highlighting the cells to apply the format?

macro to select cells based on status of cells to left

Loop to select range of cells representing a month....

Bookmarks

Bookmarks

Posting Permissions