I have Excel for Mac 2011
I need to perform a series of key strokes but haven't figured out how to do it.
For example, i need to press a + enter in a selection of cells.
the code i have right now is
Sub a_enter()
Dim cell As Range
For Each cell In Selection
cell.Select
SendKeys "a", True
SendKeys "ENTER", True
Next cell
End Sub
But it returns an error Run-time error '5': invalid procedure or argument...
how can i do it?
Don't ever use SendKeys! Very difficult to control. Use, this ...
Please Login or Register to view this content.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thank you very much! I would still appreciate if you could please teach me the syntax of how i should use sendkeys in excel for mac. The approach you showed me does solve my problem for that particular issue.
Best
Alonso
Thanks for the rep.
Sorry. 1) I do not know how you use Sendkeys on a Mac, 2) even if I did, I would not advocate using it, and 3) it is very unreliable ... you can easily send keystrokes to the wrong application.I would still appreciate if you could please teach me the syntax of how i should use sendkeys in excel for mac.
Regards, TMS
ok, Thank you very much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks