Find exact text?
 

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

Find exact text?
 

What value are you using for the LookAt argument?

you should be using xlWhole

LookAt Optional Variant. Can be one of the following XlLookAt constants:
xlWhole or xlPart.



Note that the setting is persistent, so you shoud set it explicitely each
time your code uses the Find command.



--

Regards,

Tom Ogilvy



"davegb" wrote in message
oups.com...
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

Find exact text?
 

Wasn't using the LookAt argument, so I guess it must default to part. I
put it in as "whole" and the macro works great.
Thanks, Tom.

Tom Ogilvy wrote:
What value are you using for the LookAt argument?

you should be using xlWhole

LookAt Optional Variant. Can be one of the following XlLookAt constants:
xlWhole or xlPart.



Note that the setting is persistent, so you shoud set it explicitely each
time your code uses the Find command.



--

Regards,

Tom Ogilvy



"davegb" wrote in message
oups.com...
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