Copy Range of Cells X Number of Times

**Justair07** · 11-30-2017, 08:37 AM

Hello,

I was hoping someone could help me with some vba that will copy a selected range e.g. (A2:AC11) down x number of times. Maybe prompt the user with an inputbox how many times they want the range copied.

Thank you,

Justin

**davesexcel** · 11-30-2017, 09:07 AM

Test this out.

Please Login or Register  to view this content.

**Justair07** · 11-30-2017, 09:17 AM

Thank you Dave!!!

**mehmetcik** · 11-30-2017, 09:45 AM

Same thing without loops

Please Login or Register  to view this content.

**Justair07** · 11-30-2017, 09:56 AM

Very Nice! Thank you as well!

**davesexcel** · 11-30-2017, 10:04 AM

Run both codes, see if you get the same results

Copy Range of Cells X Number of Times

LinkBack

Thread Tools

Rate This Thread

Display

Copy Range of Cells X Number of Times

Re: Copy Range of Cells X Number of Times

Re: Copy Range of Cells X Number of Times

Re: Copy Range of Cells X Number of Times

Re: Copy Range of Cells X Number of Times

Re: Copy Range of Cells X Number of Times

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] How do i get excel to count the number of times a word appears in a range of cells?

[SOLVED] Copy rows/range and paste n number of times based on last used cell in Column A

[SOLVED] Copy cells X number of times [ Without Changing the order ]

Copy selection of cells X number of times

highlight the highest and lowest number in a range of cells several times in the same c

[SOLVED] Copy set number of cells a set number of times within same worksheet

[SOLVED] Count number of occurences of values over range of cells that occur at least Three times.

Bookmarks

Bookmarks

Posting Permissions