The code line below works for my PC but when I try to run the command on Mac excel I get an error message. The short cut key is the same in both a PC and Mac. The application sendkey is for a data validation drop down list. When the user changes "target" the target.offset(0,1) will have a list data validation and using the sendkeys will automatically display the dropdown list with code below. Any thoughts on why I get an error message with the below line of code. Is the syntax for sendkey correct? 


Target.Offset(, 1).Application.SendKeys ("%{DOWN}")