SendKeys Problem

Hi,

There are 2 Macros in the attached file.

Elm1 is the "elegant" one which works perfect.

As I'm studying VBA (by myself) I came across the SendKey command - so I tried to implement the {DOWN} command but with no success (see Elm2).

It is important for me to understand why Elm2 - as is - does not present the same results like Elm1.

(Every Macro should be executed 5 times).

I'm familiar with the fact the SendKeys should not be run from within the VBA Editor (with F8 or F5) and therefor I declared the Ctrl+Shift+O shortcut to Elm2 Macro.

Thanks in advance for any assistant, have a nice weekend

Elm

Hello ElmerS,

The reason your code didn't go down to the end of the range is simple. If you want to advance one row on the worksheet, press the Down Arrow. To go to the end of the column requires 2 keys: END and the DOWN ARROW. Also, for SendKeys to work, the worksheet must be visible to you. Here is simple macro to go down to the end of a column.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Dave & Leith,

Thanks for your efforts.

I do hope you checked out the attached WB.

Elm1, which works fine, has and needs 2(!) VBA command only.

Elm2 is my problem.

I did not asked for a solution - Elm1 is the best and shortest solution.

In addition - elm1 finds the last cell "very easily" without any Sendkeys.

My question and request is to know why the Down-Arrow sendkeys command does not work.

The sheet was visible when I pressed Ctrl+Shift+O.

Please, try to understand my question as it is very simple.

I want Elm2 to do EXACTLY what Elm1 does.

You may change some of the commands as long as the Application.SendKeys ("{DOWN}") - remains in that code.

I started this task by recordind the various steps.

The Down-Arrow was recorded as: Range("xx").select

This is the command that I want to change to the Application.SendKeys ("{DOWN}").

I repeat that this is not a "looking for a solution" Question (as Elm1 provides all I need) - it is simply a wondering out of curiosity question.

Thanks for your efforts,

Elm

bth: I didn't get any E-Mail notification, like in the past, for both your posts - although Notification Type is: Instant email notification

Hello ElmerS,

If you read my post, you will find the explanation as to why the SendKeys wasn't working correctly. You failed to include the End key in the string.

Sincerely,
Leith Ross