Applescript - Excel - Change Format of Cell

Scripting Forums AppleScript | Mac OS X
#1

Hi there,

Have done a few searches on this, but haven’t found a method yet that works for me.
I would like to set the Cell Format of a column in Excel to Text or Numbers or General.

I have tried using the script below, but I get an error that the Applescript event handler has failed.

tell application "Microsoft Excel"
   set number format of (cells of (sheet "Sheet1" of active workbook)) to "general"
end tell

I’m using Excel v14.3.9 (2011) on OS High Sierra
Any ideas?

#2 

tell application "Microsoft Excel"
	set myCells to cell "$A1:$B20" of worksheet "Sheet1" of active workbook
	set number format of myCells to "General"
end tell