Hi Guys i'm writing a macro in excel that need a down arrow send at one point. Below is the script

Sheets("1").Select
Range("A4").Select
Selection.End(xlDown).Select
Sheets("2").Select
Range("A4").Select
Range(Selection, Selection.End(xlDown)).Select
Range(Selection, Selection.End(xlToRight)).Select
Selection.Copy
Sheets("1").Select
ActiveSheet.Paste
Selection.End(xlDown).Select
SendKeys ("DOWN") ' I need to send the down arrow here'

How do i do it
Rgds,

it still Dosent work, the send down dosen't happen, any idea's

Edited 6 Years Ago by gha1d: n/a

Ok.
I tried this out myself.
Replace the SendKeys line with: Application.SendKeys "{DOWN}", True

Ok.
I figured it out.
Replace all instances of SendKey "{DOWN}" with this line: ActiveCell.Offset(1, 0).Select

Fantastic. It works.. Thanks Bro. Thats 1 Hours work reduced to a few seconds.God Bless you

This question has already been answered. Start a new discussion instead.