On May 11, 9:17 am, hawki wrote:
I assigned a shortcut key to a macro using "ctrl" and a letter. The
following "sendkeys string:=" does not function properly. If I run the
macro without the shortcut key, the macro runs properly. Is there a remedy
so that the macro may run using the shortcut key? The macro line is as
follows:

Sub lop()
For count = 1 To 3
SendKeys String:="={left}-4~{down}"
Next count
End Sub

Spreadsheet example:

21 active cell (macro is run from the active cell)
24
33

--
l-hawk

Hello Hawki,

If you want to move 4 cells to left and then down, try this...

Sub Lop()
For count = 1 To 3
SendKeys "{Left 4}"
SendKeys "{Down}"
Next count
End Sub

Sincerely,
Leith Ross