How to select next non-empty cells in a Numbers app?

Questions & Suggestions
, ,
21

@Sleepy But in this scenario, it did surprise me in a pleasant way when I was not giving the full details. :joy:

22

Just spotted this thread. I believe the OP's problem has been solved by @Sleepy and others, but I didn't see any AppleScript mod to the script posted by OP @Alice_Shi "to select all next non-empty cells in numbers app". So here's my take on one:

--selects from current cell through cell before next blank (or non-blank) cell in column
--select starting cell, and run
property searchFor : missing value
tell application "Numbers"
	set t to front document's active sheet's first table whose selection range's class is range
	tell t's selection range
		set currentRow to its first cell's row's address
		set searchCol to its first cell's column's address
	end tell
	tell t's column searchCol
		repeat with i from currentRow + 1 to count cells
			if cell i's value is searchFor then --add not if want to find non-blank
				exit repeat
			end if
		end repeat
	end tell
	--
	set colName1 to character searchCol of "ABCDEFGHIJKLMNOPQRSTUVWXYZ"
	set rangeAddr to (colName1 & currentRow & ":" & colName1 & i - 1) as text
	tell t to set selection range to range rangeAddr
end tell

Hope it's of some use.