I have a range of cells that hold headers for each column. Within this range, I want to be able to select a set of cells and add them to an array. The problem, as ever, is that each time this is used, the number of cells in the subset could be different. Here is what is always true though:
1. The subset of cells always begins on cell F1.
2. The cell after the last cell in the subset, always states "is_success" in it.
All the cells in between these two points are what I want to pass to the array. It is not the contents of the cell that I want to pass, but the cell references (F1, for example).
Any suggestions on this would be gratefully received.
Thanks folks
1. The subset of cells always begins on cell F1.
2. The cell after the last cell in the subset, always states "is_success" in it.
All the cells in between these two points are what I want to pass to the array. It is not the contents of the cell that I want to pass, but the cell references (F1, for example).
Any suggestions on this would be gratefully received.
Thanks folks