hi all,
How would I go about adding the address of a cell to an array?
To be specific, I'm testing cells in a range for a value (lets call it X). If that value is true Then add cell.address to array. I'm using an array because I would like to work with all cells where X = true later down the line. I *Think* creating an array is my best option as I cannot assign each its own variable as I do not know how many cells where this value will be true there are.
Thanks all!
How would I go about adding the address of a cell to an array?
To be specific, I'm testing cells in a range for a value (lets call it X). If that value is true Then add cell.address to array. I'm using an array because I would like to work with all cells where X = true later down the line. I *Think* creating an array is my best option as I cannot assign each its own variable as I do not know how many cells where this value will be true there are.
Thanks all!