Copy and Paste

[rizmomin]

Hello:

I have sheet with B1 = "Store1"

I need VB Code to copy the text which is in cell B1 in very 44 th row in column B until last row 1334.

let me know if any questions.
Thanks
Riz

[ncmay]

This code will paste the value of cell B1 in cells B44, B88, B132, B176.... to B1320.
In doesn't put anything in B1334.

Please Login or Register  to view this content.

[rizmomin]

Hi ncmay:

Thanks a lot, works

Riz