Insert Copied Rows And Maintain Selection

[Draperies]

Right now I have a macro that takes previously copied cells and inserts them to a new location using the following code:

Selection.EntireRow.Insert Shift:=xlDown

This works well enough except the copied cells are no longer selected after the insert, which I need so I can work with the selection. I have tried setting the active cell as a starting point and trying to figure out the number of rows of the selected text by creating a MSForms.DataOjbect but have had absolutely no luck going about it in this way. Does anyone have any suggestions?

 

[GlennUK]

Show the code that does the Copy processing.

 

[Draperies]

Unfortunately there is no code that does the copying process. The user selects a range in another workbook and presses copy before running the macro.

This is also part of the reason why I had wanted to be able to work with the clipboard (so I could check and make sure they had copied valid information, enouch cells, etc. before continuing the macro). However, I'd certainly just be happy to do the insert and keep the inserted cells selected.