Excel: Append Named Ranges one under the other to form a new Range

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 with trying to loop and update the last row of the AppendedRange. I would appreciate any help. Thanks, Tamir

This question generated 11 answers. To proceed to the answers, click here.

This thread is current as of April 16, 2017.

For more resources for Microsoft Excel