Maria

I tried it with IFN FP Equity in Column J and it was NOT selected; I see no
possible reason for it selectin "IFN FP Equity". When I changed it to "IFN FP
Equity GR" then it was changed!

In my workbook I had worksheets 1999 and 2000 as a test and BOTH were changed.

So I don't have a clue as to why yours is not working.

Did you simply cut & paste the code?



"mariasa" wrote:


Thank you for ur response, Toppers. I tried it out and for some reason
it performed the sub only on ws 2006 and the rows it highlighted were
not exclusively the ones that had GR in column J as part of the string.
For example IPN FP Equity was the one picked up when looking for GR.
Strange..Do you have an idea of what could have gone wrong?

Thanks

Maria


--
mariasa
------------------------------------------------------------------------
mariasa's Profile: http://www.excelforum.com/member.php...o&userid=31726
View this thread: http://www.excelforum.com/showthread...hreadid=557535

If you want, post w/b to toppers<atjohntopley.fsnet.co.uk and I will have a
look at it.

"Toppers" wrote:

Maria

I tried it with IFN FP Equity in Column J and it was NOT selected; I see no
possible reason for it selectin "IFN FP Equity". When I changed it to "IFN FP
Equity GR" then it was changed!

In my workbook I had worksheets 1999 and 2000 as a test and BOTH were changed.

So I don't have a clue as to why yours is not working.

Did you simply cut & paste the code?



"mariasa" wrote:


Thank you for ur response, Toppers. I tried it out and for some reason
it performed the sub only on ws 2006 and the rows it highlighted were
not exclusively the ones that had GR in column J as part of the string.
For example IPN FP Equity was the one picked up when looking for GR.
Strange..Do you have an idea of what could have gone wrong?

Thanks

Maria


--
mariasa
------------------------------------------------------------------------
mariasa's Profile: http://www.excelforum.com/member.php...o&userid=31726
View this thread: http://www.excelforum.com/showthread...hreadid=557535

Toppers,

my bad, i think the issue was in the ordering of the worksheets. it was
2006 to 1999 and i did it 1999 to 2006 this time and it worked
perfectly, so yea, thanks a lot for ur code, i seem to be all set now
:)

Kind Regards,
Maria


--
mariasa
------------------------------------------------------------------------
mariasa's Profile: http://www.excelforum.com/member.php...o&userid=31726
View this thread: http://www.excelforum.com/showthread...hreadid=557535