Hello, i was wondering if there is a way to have a range that is created "RNG" and have it copy and pasted above the original range
So i have a range from rows A5:A10 called RNG.
the rows have just
1
2
3
4
5
with the empty row above the 1 being part of the range, I would want that range copied and shifted down with the same format pasted above it, using the range to know what format to get
because i am going to try and create a button to ask a user to select a range and how many times to replicate it
so if chose 1 more to add it would be, or if they added 2 but actually needed more they could do so even after adding some of the range already
1
2
3
4
5
1
2
3
4
5
So i have a range from rows A5:A10 called RNG.
the rows have just
1
2
3
4
5
with the empty row above the 1 being part of the range, I would want that range copied and shifted down with the same format pasted above it, using the range to know what format to get
because i am going to try and create a button to ask a user to select a range and how many times to replicate it
so if chose 1 more to add it would be, or if they added 2 but actually needed more they could do so even after adding some of the range already
1
2
3
4
5
1
2
3
4
5