Paste every 149 rows many times (excel 2010)

[mafix84]

Good Morning, i need your help.

in column A i have to copy a cell to the 148 empty cell below (sterting from A1), and repeat this, for all the sheet.

can you help me with a VB formula?

thank you.
Jack

[HaHoBe]

Hi, Jack,

could you pass on additional information: which cell is to be copied, are there values in the other cells on that sheet, which column(s), how to determine on to which row to fill?

This code will fill in the contents of Range E1 into the area between 2 and 1491:

Please Login or Register  to view this content.

Ciao,
Holger

[mafix84]

i've to work just in column A, i've a value in cell A1, i need to copy it in the following 148 cells below, then in cell A150 another value, and i've to copy it in the following 148 cells below, etc...
I must do it for more or les 15000 times.
Please help me.

[HaHoBe]

Hi, Jack,

maybe try this code:

Please Login or Register  to view this content.

Ciao,
Holger

[mafix84]

it's work.

THANK YOU VERY VERY VERY MUCH HOLGER.

[sktneer]

For all sheets you can try this.

Please Login or Register  to view this content.

[HaHoBe]

Hi, sktneer,

the question wasn´t to copy the range between 1 and 149 for all sheets in a workbook but to do in one Column on one sheet muliple times.

Ciao,
Holger

[sktneer]

Hi, sktneer,

the question wasn´t to copy the range between 1 and 149 for all sheets in a workbook but to do in one Column on one sheet muliple times.

Ciao,
Holger

I got confused probably what the OP says like....

"in column A i have to copy a cell to the 148 empty cell below (sterting from A1), and repeat this, for all the sheet."

Thanks for pointing it out though.