Macro to copy cell down

[Bob K.]

I want to create a macro that will copy the cell above to the active
cell.
OR the built-in key that will do that

[email protected]

 

[Gord Dibben]

Bob

A few seconds with the macro recorder set to "Relative Reference" gave me
this.

Sub Macro1()
'
' Macro1 Macro
' Macro recorded 11/3/2003 by Gord Dibben
'

'
Selection.Copy
ActiveCell.Offset(1, 0).Range("A1").Select
ActiveSheet.Paste
Application.CutCopyMode = False
End Sub

Gord Dibben XL2002

 

[Bob K.]

Where, in macro recording, do I set this to Relative Reference

 

[Bob K.]

Thanks for the fast reply, Gord
Where do I set the recorder for Relative Reference --

 

[Gord Dibben]

Bob

Should be a "relative reference" button on the Stop Recording Toolbar that
pops up when you go to Tools>Macro>Record New Macro.

Also should be on the Tools>Macro fly-out menu.

Sounds like you're just getting started at this macro thing. Good way to get
your feet wet is to record some moves.

David McRitchie has a "getting started" page on his website.

http://www.mvps.org/dmcritchie/excel/getstarted.htm

Note the links down near the bottom under "Related". The link to VBA 101 is a
good one.

Gord

Thanks for the fast reply, Gord
Where do I set the recorder for Relative Reference --

Gord Dibben XL2002

 

[Dana DeLouis]

OR the built-in key that will do that

To copy the cell above the active cell to the active cell, I believe that
would be Ctrl + "D"

A recorded macro would be...

Sub Demo()
ActiveCell.FillDown
End Sub


HTH