Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro Code
You'd think this would be simple...
How do I get a macro to move down 1 cell? I just want a macro to copy the contents of one cell to the cell below it. I have already done this: Sub CopyDown() ' ' CopyDown Macro ' ' Keyboard Shortcut: Ctrl+d ' Selection.Copy Range("A122").Select ActiveSheet.Paste End Sub I want the A122 to be the cell below where the cursor happens to be when I kick off the macro. Any help would be appreciated. Amy |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro Code
Got it from the last thread... thanks!
"cvgairport" wrote: You'd think this would be simple... How do I get a macro to move down 1 cell? I just want a macro to copy the contents of one cell to the cell below it. I have already done this: Sub CopyDown() ' ' CopyDown Macro ' ' Keyboard Shortcut: Ctrl+d ' Selection.Copy Range("A122").Select ActiveSheet.Paste End Sub I want the A122 to be the cell below where the cursor happens to be when I kick off the macro. Any help would be appreciated. Amy |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro Code
Hi,
2 ways ActiveCell.Copy Destination:=ActiveCell.Offset(1) or ActiveCell.Offset(1) = ActiveCell.Value -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "cvgairport" wrote: You'd think this would be simple... How do I get a macro to move down 1 cell? I just want a macro to copy the contents of one cell to the cell below it. I have already done this: Sub CopyDown() ' ' CopyDown Macro ' ' Keyboard Shortcut: Ctrl+d ' Selection.Copy Range("A122").Select ActiveSheet.Paste End Sub I want the A122 to be the cell below where the cursor happens to be when I kick off the macro. Any help would be appreciated. Amy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Code | Excel Discussion (Misc queries) | |||
Macro code | Excel Discussion (Misc queries) | |||
VBA code for macro help | Excel Discussion (Misc queries) | |||
Deleting code from a macro (by a macro) | Excel Discussion (Misc queries) | |||
Help With Macro Code?? | Excel Worksheet Functions |