Hi,
I have many ranges on the same sheet, each contains exactly 1 column.
Range1, Range2, Range3...etc.
I need to create a combined range ("AppendedRange") that will append all the ranges, one under another (for vlookup purposes)
Range1 (values)
Range2 (values)
Range3 (values)
etc.
I got lost...