Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA code for pressing "down arrow" in recording macro
I'm recording a copy/paste macro, using 'end' 'down arrow' to get to bottom
of list and then press the down arrow. When I press the down arrow, I just want the code to appear for pressing the down arrow, but instead it puts a range command with a specific cell location, like A1046. What can I replace this statement with, so I can just go down one cell, so it can start the copy/paste? Here's the code: (I want to keep this code, but just change the "Range("A1041").Select" part to reflect pressing the down arrow key, instead of actually giving me a "cell" location.) Can anyone help? thx Dotti Application.Goto Reference:="DataOtherEquip" Selection.Copy Sheets("SQL Equip").Select Range("A2").Select Selection.End(xlDown).Select ' note for Dotti - change this next statement to reflect 'down' one cell instead of a range Range("A1041").Select ActiveSheet.Paste Range("A1").Select Sheets("Other Equip").Select Range("A1").Select Application.CutCopyMode = False Sheets("SQL Equip").Select End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening the Macro "Stop Recording" tool bar | Excel Programming | |||
colour fonts revert to black when pressing "Enter" | Excel Discussion (Misc queries) | |||
How do I turn on "pressing enter goes to the next cell" option? | Excel Discussion (Misc queries) | |||
Pressing "Enter" to run macro | Excel Programming | |||
Problem- Recording macros for "file save" and "File open" | Excel Programming |