Copy and past row range based on value in another cell

**mariannehislop** · 03-26-2021, 06:47 AM

Trying to find a VBA code that will copy a row range (A6:T6) and paste below a number of occurrences specified in cell N1. Attached is a copy of the spreadsheet of what I am working on.

Thanks in advance.

**Marc L** · 03-26-2021, 07:16 AM

According to your explanation that just needs this single codeline : [A6:T6].Copy [A7].Resize([N1].Value2) …

**mariannehislop** · 03-26-2021, 07:52 AM

Thank you Marc. Brilliant. Well, that was simpler than I thought.

Thanks again

**mariannehislop** · 03-26-2021, 07:34 PM

This worked brilliantly when I tried it last night, however today I am getting a compile error: Invalid outside procedure and it highlights the [N1]?

**Marc L** · 03-26-2021, 10:22 PM

Thanks for the rep' !

According to your message error it seems you paste the codeline outside of a VBA procedure as it must be between Sub … End Sub codelines.

**mariannehislop** · 03-27-2021, 05:43 AM

Thanks Marc. Yes I sorted it out. I don't know how it actually worked previously????

Copy and past row range based on value in another cell

LinkBack

Thread Tools

Rate This Thread

Display

Copy and past row range based on value in another cell

Re: Copy and past row range based on value in another cell

Re: Copy and past row range based on value in another cell

Re: Copy and past row range based on value in another cell

Thread Information

Users Browsing this Thread

Similar Threads

Copy past only values based on cell selection range

[SOLVED] Copy and past row to another sheet based on date range.

copy/past rows based on a value in a new worksheet

[SOLVED] select & copy some range and past it to another sheet with sum

Automatically Copy and Past a Variable Number of Cells Based on a Cell Reference

Linking data based on a cell value and copy/past to another worksheet??

Copy last formula in column and past into range

Bookmarks

Bookmarks

Posting Permissions