Thanks for all the help in advance.
- is there a way to increment a cell reference without separating the column and row references?
First instance you have a
a cell “A1” and you would like to increment just the cell reference by 2 so then you have a cell reference to “A3”
You can separate the two references “A” and “3” then increment the “3” but I was wondering if anyone has code that you can just add A3+2 and get A3+5?
set sourceCell to reportofColum & c
set compareCell to reportofColum & (c + 1)
- Is there a way to define a range in a list? ex. 1 to 5
list x contains values from 1 to 5?
what works:
set list to {1,2,3,4,5}
Something like this:
set list to range {1…5}