Coming soon - Get a detailed view of why an account is flagged as spam!
view details

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.

2
[EXCEL] How to copy and insert a specific range over a user-selected row?
Post Flair (click to view more posts with a particular flair)
Author Summary
boycott_nestingdolls is in Excel
Post Body

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)

  1. Copy/insert a specific range ("SPEC") above the range itself ("SPEC")

But what I would like to do is:

  1. Copy the specific range ("SPEC")
  2. Prompt user to select a row
  3. 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.

Author
Account Strength
100%
Account Age
10 years
Verified Email
Yes
Verified Flair
No
Total Karma
37,681
Link Karma
3,552
Comment Karma
33,788
Profile updated: 4 days ago
Posts updated: 1 month ago

Subreddit

Post Details

Location
We try to extract some basic information from the post title. This is not always successful or accurate, please use your best judgement and compare these values to the post title and body for confirmation.
Posted
4 years ago