Missing value in AppleScript -

Missing value in AppleScript -

can help me remove error?

error "missing value can not converted type number." number -1700 missing value number

tell application "numbers" activate open thefile tell first table of active sheet of document 1 repeat 2 count of rows of column "d" set val1 value of cell of column "d" set value of cell of column "d" val1 * -1 end repeat end tell end tell

thank you!

basically happen when cell doesn't have value must have empty rows in table. easiest thing utilize seek block ignore errors when can't multiply val1 -1.

tell application "numbers" activate open thefile tell first table of active sheet of document 1 repeat 2 count of rows of column "d" set val1 value of cell of column "d" seek set value of cell of column "d" val1 * -1 end seek end repeat end tell end tell

applescript