Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

Vreditel

macrumors newbie
Original poster
Jul 28, 2011
11
0
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?
 
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.
 
Thank you for answer, i'm look again Excel dictionary and try to set selection to "".
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.