TamirBasin
New Member
- Joined
- Apr 11, 2017
- Messages
- 49
- Office Version
- 365
- Platform
- Windows
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
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