Repeat Action

Scripting Forums AppleScript | Mac OS X
#1

I was able to figure out how to repeat through one list but cannot figure out to repeat through a second list.

Every item in the row list needs to be executed for every met in the column list;
D3, D4, D5, etc…

I’m lost and would appreciate the help.

set AllColumns to {"D", "F", "H", "J", "K", "L", "N", "P", "R", "T", "U", "V", "W", "X", "Y", "Z", "AA", "AB", "AC", "AD"}
set AllRows to {"3", "4", "5", "8", "9", "10", "13", "14", "15", "18", "19", "20", "23", "24", "25", "28", "29", "30", "33", "34", "35", "38", "39", "40"}

tell application "Numbers" to tell front document to tell active sheet
	repeat with EachColumn in AllColumns
		set AllCells to {EachColumn & "3", EachColumn & "4", EachColumn & "5"} -- As well as repeat through all rows listed above
		tell first table
			repeat with EachCell in AllCells
				set the value of cell EachCell to ""
			end repeat
		end tell
	end repeat
end tell
#2

maweir. I’m not certain I understand what you want to do but try the following. I simplified the rows and columns just for testing.

set AllColumns to {"A", "B", "C"}
set AllRows to {"3", "4", "5"}

tell application "Numbers"
	tell table 1 of sheet 1 of document 1
		repeat with EachColumn in AllColumns
			repeat with eachRow in AllRows
				set the value of cell (EachColumn & eachRow) to ""
			end repeat
		end repeat
	end tell
end tell
#3

Perfect!