Shift Excel Cell after executing a macro for second time

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Shift Excel Cell after executing a macro for second time

FAQ

Thread Tools

Display Modes

01-08-2015, 02:54 PM

charlesdh

Windows 7 32bit Shift Excel Cell after executing a macro for second time

Office 2010 32bit

Expert

Join Date: Apr 2014

Location: Mississippi

Posts: 382

HI,

Have the file Destination go to another part of the sheet and then you copy the data to "A1" and have it insert the copied data and at the same time move the file down.
This is a recorded macro. But it may help.

Code:

Sub Macro3()
    Range("H1:H3").Copy
    Range("A1").Select
    Selection.Insert Shift:=xlDown
    Application.CutCopyMode = False
End Sub

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Delete empty cell and shift up	Linh	Word Tables	1	09-21-2014 01:52 PM
Excel 2013 – need help extracting date and time from text cell plus more.	Art Mann	Excel	1	07-18-2014 09:55 PM
Can anyone here tweek this macro for renaming Excel files based on a cell's contents?	chrisd2000	Excel Programming	6	07-01-2014 01:53 PM
Shift cell right	gsrikanth	Excel Programming	2	01-17-2012 11:29 PM
Cell formatting for time - Excel 2010	PomDave	Excel	5	09-05-2011 10:49 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:16 AM.