Looking at every column in worksheet would be resource-intensive and error prone. Better to find the right columns and only look at appropriate ranges. If you know what the column header will be, it's easy to search for that text and base range off of the result. Let us know if that will work for you.