Insert rows instead of copying rows

[Henk]

I am looking for help with a macro who is coping a "named range" from a sheet that contains a large list of named ranges.

The active sheet has 20 or more named ranges. This list can grow and shrink.

The macro below is everything what I need, but, the macro is not moving data but overwriting other data.

When the named range is copied it will need to move and insert the data in the active sheet, not overwriting.

For testing purposes I created 3 name ranges: "ABC", "DEF" and "GHI".
(attachment is anonymised)

Is that possible?

Please Login or Register  to view this content.

[karmapala]

Please Login or Register  to view this content.

Since I don't know how do you want to insert and how the user select the range,
so the things which I tested are :
- Choose ABC from the ListBox
- Choose cell A13 for the InputBox.
Then the macro copy the ABC named range and then insert the copied cell starts from cell A13.

The image below, I choose range DEF and choose cell A8
2021-09-21_00-43-26.gif

[Henk]

Hello Karmapala,

Thanks for looking into my "problem".

I change

Please Login or Register  to view this content.

into

Please Login or Register  to view this content.

and thats all what I need.



Thanks, my "problem" is solved.

Henk

[karmapala]

Thank you, Henk.