• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2363
  • Last Modified:

How to Insert Copied Cells in Excel VBA

In a spreadsheet, I can select a range and insert the cells, shifted right.

How do I do the same in VBA code?
0
JoeLalor
Asked:
JoeLalor
1 Solution
 
craigewensCommented:
Play about with this:

Range("A5:E5").Select
Selection.Copy
Range("A2").Select
Selection.Insert Shift:=xlToRight
0
 
CleanupPingCommented:
Hi JoeLalor,
This old question (QID 20567546) needs to be finalized -- accept an answer, split points, or get a refund.  Please see http://www.cityofangels.com/Experts/Closing.htm for information and options.
0
 
GPrentice00Commented:
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

 -->Accept craigewens's comment as Answer

Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER

GPrentice00
Cleanup Volunteer
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now