This post has been de-listed
It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.
I would like to allow users to copy/insert a specific range ("SPEC") in between any row they select.
I've been able to do the following:
1. Insert a blank row over a user-selected row (prompted with an input box)
- Copy/insert a specific range ("SPEC") above the range itself ("SPEC")
But what I would like to do is:
- Copy the specific range ("SPEC")
- Prompt user to select a row
- Insert the specific range ("SPEC") above that row
Here is the current code I've gotten to, but it's overwriting the active range and just inserting a blank row. I can't figure out how to get it to paste the copied selection where the user wants it.
Dim Rng As Range
Range("SPEC").Select
Selection.Copy
Set Rng = Application.InputBox("Select a row", Type:=8)
Rng.Insert Shift:=xlDown
Any ideas or leads as to what I can use to accomplish this? I'm a self-taught user so I'm sure there are tools out there that I'm not aware of.
Subreddit
Post Details
- Posted
- 4 years ago
- Reddit URL
- View post on reddit.com
- External URL
- reddit.com/r/vba/comment...