Get headers not in first row in Google sheets

[Will_Tyler]

This is a strange happening. I have a Google sheet that has several rows of “information” then there’s a row with headers (ie. row 10 has the headers) but the possibility is there that it could be dynamic, so instead of row 10 it may be 9 or 11, for example.

I can read the whole range then go through a “Do while” row(0)(1) doesn’t contain the keyword for the header remove that row. That seems to work but then when I do a “(From dc In dtFilteredTable.Columns.Cast(Of DataColumn) Select dc.ColumnName).ToArray()” and get the first header it’s the first row that was already removed. If I paste the datatable to a new Excel sheet and read it back in it works but I don’t want to go add that complexity.