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.
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.
Last edited by mariannehislop; 03-26-2021 at 07:40 AM.
According to your explanation that just needs this single codeline : [A6:T6].Copy [A7].Resize([N1].Value2) …
Thank you Marc. Brilliant. Well, that was simpler than I thought.
Thanks again
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]?
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.
Thanks Marc. Yes I sorted it out. I don't know how it actually worked previously????
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks