How Can I Use SendKeys in MAC EXCEL?

[kenji4861]

I'm trying to do

sendkeys "{f2}{end}{right}"

but the mac version of excel gives me this error

Run-time error '5':
Invalid procedure call or argument

 

[J.E. McGimpsey]

That's because SendKeys doesn't work in MacXL.

OTOH, even if it did, the keymapping for the function keys are
different - F2 doesn't enter Edit mode (unless you redefine the key
- see http://mcgimpsey.com/excel/f2.html).