You could use some code like this in your current macro:
<pre>Dim rHeader As Range
Set rHeader = Range(“a1:z5″).Find(“90_day_Late”)</pre>
and then change this line:
In this example it will look for the desired header in range a1:z5. If it is outside that range it won’t find it.
If there is a chance that the header is not present, you should add some code to validate it, because in that case “rHeader.Select” would produce an error.