I am trying to take the value of several selected cells (e.g. A1:A4 or A1, A6, B5) and then process each value one by one in a loop. So, there are two step. One, to get the values. And two, to process the values in a loop. I don't know how to get the value of several selected cells and I don't know how to process these values in a loop.
With a single selected cell it is easy. See script below:
But I can't do the same with several selected cells. I tried the following. See below. This script doesn't work, but it illustrates the line I am thinking along. Perhaps from that attempt you can understand what I am trying to do.
I became pretty good at working cell by cell but I have a long way to go to comfortably work with ranges.
I would greatly appreciate if somebody could help me out on this one.
Bookmarks