applescript numbers - rearrange / move columns

Don't think there is an easy way to do that by script. Sometimes doing things manually is much more efficient.

The only way via script that I can get to work here is to do "gui-scripting", something like this, to switch the positions of column B and C, with an empty column D.

tell application "Numbers"
	tell active sheet of front document
		tell table 1
			set selection range to column "B"
			activate
			tell application "System Events" to keystroke "c" using command down
			set selection range to column "D"
			tell application "System Events" to keystroke "v" using command down
			delay 0.5
			delete column "B"
		end tell
	end tell
end tell

SG

Hi Bert,

"two questions: what is the delay good for ?"

It gives the system time to complete the previous task ('paste all this stuff into column D') before starting the next one ( Delete column B).

" how to deselect a range at the end ?"

When the script is finished, click wherever your next task is to be done to select that location (and deselect the previously selected range).

one question: how did your postˆ"Thanks SG…the end?" solve your issue?

The Solved button marks the post as having solved the issue, and brings it to the top of the discussion, where it is more likely to be seen by someone arriving later with a similar or the same question.

Regards,

Barry