I have a worksheet where my data is stored in columns. Once once column becomes full another one is started, which is not adjacent to the previous one.
All of the data contained within these multiple columns have been assigned to a single named range, "xData".
Is it possible to select a subset of consecutive values from this named range? For example the 10th to 20th values.
Many thanks
Bookmarks