My macro searches for text in column headers from a list in a
spreadsheet and replaces that text with other text, also from the list.
For example, the first cell in the source spreadsheet might contain
"a", the cell to the right contains "b". The macro searches for "a" and
when it finds it, replaces it with "b". It then repeats itself using
the next row until it gets to a blank cell.
I have 2 column headers that are similiar, "stcounty" and "county". I
want to replace "stcounty" with "County of Inv" and "county" with
"County of Serv". Right now the macro replaces "stcounty" with "County
of Inv" but doesn't change "county" to "County of Serv". I've tried a
couple of different varations in the code, but can't get it to change
the second occurrence of "county". I'm sure someone here knows how to
fix this.
TIA