Used with the SendKeys statement, % represents the Alt key, and ~
represents the Enter key.
When a cell that contains a comment is selected, it's like pressing
Alt+I (to open the Insert menu), then E (to highlight Edit Comment),
then pressing the Enter key to activate the command.
Robbyn wrote:
Hi Debra. I checked out your code for comments and am wondering what 'SendKeys "%ie~" does?
Robbyn
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html