Excel 2011 - Select all and Clear All Content

Scripting Forums AppleScript | Mac OS X
#1

I am hoping this is a simple question but I had little luck finding it here. (Plus, i have never scripted for Excel, so the dictionary isn’t doing much for me either) :frowning:

I would like to open a document with preset cell formats and clear its contents. So assuming the document is already open, what is the best way to select all and clear or delete all its cells?

Thanks in advance,
-Jeff

#2

You can try something like:

tell application "Microsoft Excel"
	clear range (range "A:C" of worksheet "Sheet1" of workbook "Workbook1")
end tell
#3

That’s perfect Adayzdone, that’s all I needed. I’ll makes sure to set the range wide enough to cover all scenarios.
Many thanks.
-Jeff