aarodn
You should remember, one of the most important issue to write the code is to get the correct data range, otherwise the code will never work.
Your first sheet has Column A blank (I don't like it though), so I wrote
This gets the range of rectangle area includes "B1" until the boundary of blank row/column.
So the relative col reference within the data area will shift by 1 from the actual sheet col reference.
Now you have data from A1, which I prefer, so now the col reference is identical to the sheet.
Now Col.A = 1, Col.B = 2 etc. Was Col.B = 1, Col.C = 2 etc.
Bookmarks