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.