Paste in to specifed columns (10 to the right) on next iteration of loop

**stevoDE** · 06-30-2017, 06:46 AM

Hi

I have a 'for i = 1 to 3' loop running through the first 3 sheets where I am applying a filter for non blanks in column H then copying all non blank rows of columns B:H.

I am trying to paste the data from Sheet1 in to cell A4 of sheet 4 then paste the data from Sheet2 in to K4 (i.e. 10 columns to the right of column A) of sheet4 then paste the data from sheet 3 in to U4 (i.e. 10 columns the right of column K).

Thanks in advance

**Kaper** · 06-30-2017, 07:14 AM

Refer to cell to paste with Cells instead of Range

so start with

dim my_column as long
my_column = 1

and then within a loop:

Cells(4,my_column)=Your_value_to_be_pasted
my_column=my_column+10

**stevoDE** · 06-30-2017, 08:54 AM

Perfect, thanks Kaper.

**Kaper** · 07-03-2017, 06:10 AM

Glad to hear it works and thanks for Rep. point and for marking thread SOLVED :-)

Paste in to specifed columns (10 to the right) on next iteration of loop

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Paste in to specifed columns (10 to the right) on next iteration of loop

Re: Paste in to specifed columns (10 to the right) on next iteration of loop

Re: Paste in to specifed columns (10 to the right) on next iteration of loop

Re: Paste in to specifed columns (10 to the right) on next iteration of loop

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] How to move to next iteration of a Do Until loop

[SOLVED] Go to next loop iteration if current loop has error

VBA - How to continue inner loop while going to next iteration of outer loop?

jump to xth iteration of for next loop

[SOLVED] Last Iteration of Loop?

[SOLVED] Loop fails on 2nd iteration

[SOLVED] [SOLVED] Loop: Copy and paste range that changes with every iteration

Bookmarks

Bookmarks

Posting Permissions