Sunday, March 18, 2018

#1 2017-10-02 09:56:21 am

Registered: 2016-10-14
Posts: 71

Applescript - Excel - Change Format of Cell

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?

running Sierra 10.12.5



Board footer

Powered by FluxBB

RSS (new topics) RSS (active topics)