I am working with numbers sheet and I want to create a keyboard shortcut so that when I press a button the script searches for the number "1" in column I, when it finds the number "1" it will increase the number by "1" [add 1 or +1] to the cell in the column left of it, in this case column H.

I searched the forums and found this:

Quickly increase/decrease cell value by 1 in Numbers

tell application "Numbers" set tTables to (tables of sheets of front document whose its selection range is not missing value) repeat with t in tTables -- tables of each sheet if contents of t is not {} then -- the list is not empty, it's the selected sheet set tCells to cells of selection range of (get item 1 of t) -- selection in active table repeat with i in tCells -- each selected cell set val to value of i set value of i to (val + 1) end repeat return end if end repeat end tell

it doesn't work because it returns:

"Numbers got an error: Can’t make missing value into type range."

when I try to see if it works from applescript.

When I try to use it in number it returns the following:

"The action “Run AppleScript” encountered an error: “Numbers got an error: Can’t make null into type range.” "

This was just so I could have a keyboard shortcut to add 1 to the value in the cell and it didnt even work.

any help would be greatly appreciated and thank you for your time and have a nice day.

  • It's much easier to do complex scripting tasks in Python. – user96931 Feb 5 at 21:13

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.