Pretty much what it says in the question.
Let’s say I have a named range which consists of cells B11:B20 (but this may change if the spreadsheet is altered). Is it possible to find the cell coordinates from the name alone? Actually just finding the first cell would be OK.
Here’s the reason I want to do this. If anyone can point me to a solution I’d be grateful.
I want to multiply all the cells in a named range by the value in one other cell.
Like this: MyRange = MyRange * MyValue
I have figured out how to access the data in the cells using .getData() but the way this returns an object consisting of an array of arrays seems clunky, there has to be an easier way! The range is always going to be 10 cells in a column so if I can find the coordinates of the top one I can do the rest by recalculating the value of each cell individually in a loop.