Clear selection in Excel

Discussion in 'Mac Programming' started by Vreditel, Sep 7, 2011.

  1. Vreditel macrumors newbie

    Joined:
    Jul 28, 2011
    #1
    Hello!!!
    I have a trouble with cleat selection in Excel sheet. I have not found a method which do it. For example-i wrote code in applescript, which selects the range in Excel sheet, then i hidden this sheet and after that i need to clear selection in the hidden sheet. Is this possible? And if yes, how?
     
  2. Hansr macrumors 6502a

    Joined:
    Apr 1, 2007
    #2
    Selection.Value = "" or Selection.Clear should work in VBA. Does it need to be AppleScript?

    There is a VBA to AS guide on MS website. Could be in there.
     
  3. Vreditel thread starter macrumors newbie

    Joined:
    Jul 28, 2011
    #3
    Thank you for answer, i'm look again Excel dictionary and try to set selection to "".
     

Share This Page