copy range value x times in another sheet

**nikenis** · 07-21-2013, 04:45 AM

Hi all,

Here is below a code that copy the desired source to destination. I would like to add a constant that will be used to copy the source x number of times.

Please Login or Register  to view this content.

**HaHoBe** · 07-21-2013, 04:53 AM

Hi, nikenis,

you should make Cells inside your Range to relate to the destination sheet as well with adding a dot before them.

You would need to adjust your code to write cells to (maybe with End(xlUp).Row + 1):

Please Login or Register  to view this content.

Ciao,
Holger

**nikenis** · 07-22-2013, 02:15 AM

Hi Holger,

Thanks for this.
I do not wish to copy the cycle down to rows but horizontally within the same row.

Regards,
Nikenis

**HaHoBe** · 07-22-2013, 02:27 PM

Hi, nikenis,

by using another loop:

Please Login or Register  to view this content.

Ciao,
Holger

**nikenis** · 07-23-2013, 11:14 PM

Hi Holger,

Many Thanks.

Regards,
Nikenis

copy range value x times in another sheet

LinkBack

Thread Tools

Rate This Thread

Display

copy range value x times in another sheet

Re: copy range value x times in another sheet

Re: copy range value x times in another sheet

Re: copy range value x times in another sheet

Re: copy range value x times in another sheet

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Macro to copy a cell range and paste to a new sheet 'n' times where 'n' defined by formula

[SOLVED] Macro to copy/paste dynamic range x times into same sheet

[SOLVED] Copy and paste a range x many times

Copy a Range multiple times

Copy range several times less first row

Bookmarks

Bookmarks

Posting Permissions