Applescript - Numbers - Setting Value of Every Cell within a Range

Hi There,

I want to select a range of cells in a numbers document and make all those cells contain the same text.
Currently this is all cells in a single column, besides the first cell, since this contains a column header.

What I have so far is this, but it’s not working!
Has anyone got any ideas?


tell application "Numbers" to tell document 1
	
	tell sheet 1 to tell table 1
		set modifiedBy to ¬
			((name of the second cell of column "H") & ":" & ¬
				(name of the last cell of column "H"))
		set the selection range to range modifiedBy
		set value of cells of modifiedBy to "Adam"
	end tell
end tell

Try :

tell application "Numbers" to tell document 1
	
	tell sheet 1 to tell table 1
		set modifiedBy to ¬
			((name of the second cell of column "H") & ":" & ¬
				(name of the last cell of column "H"))
		set value of cells of range modifiedBy to "Adam"
	end tell
end tell

Yvan KOENIG running Sierra 10.12.0 in French (VALLAURIS, France) jeudi 20 octobre 2016 15:33:21

Perfect! Thanks Yvan!