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
Bookmarks