frabulator
Active Member
- Joined
- Jun 27, 2014
- Messages
- 250
- Office Version
- 2019
- Platform
- Windows
I have been tasked with managing a very large vlookup spreadsheet that spans several disorganized books, which I promptly said, 'screw that' after I saw the mess of and organization nightmare I was getting into. So I came up with a userform that breaks down the vlookup into workbooks, sheets, tables and headers. Works beautiful, except I hit a road block.
My question is, what is the syntax to call the individual values for the HeaderRowRange of a table? IE, how can I list/loop each cell value in that headerrowrange? I am sure it is something simple that I am overlooking, but I cant seem to get it to work.
Thanks in advance
~Frab
My question is, what is the syntax to call the individual values for the HeaderRowRange of a table? IE, how can I list/loop each cell value in that headerrowrange? I am sure it is something simple that I am overlooking, but I cant seem to get it to work.
Thanks in advance
~Frab