Return index from find()

[vizzkid]

Hi,

Can I use find() to return an index/integer?

I'm using find().CurrentRegion to .Clear some stuff, I then want to re-color that area with interior.colorindex = 2 but to do that i obviously need to know what area I cleared..

I was thinking that maybe I could do (pseudo code):

Please Login or Register  to view this content.

But find() doesn't seem to be returning an integer, found_col is not working.. What am I doing wrong? Or do you have a better suggestion on how to do it?

All help greatly appreciated!

[stnkynts]

I think Instr() might be more appropriate for what you are trying to do. I think you will also need to incorporate a loop. Submit a workbook example with before and after expectations for a specific answer.

[Norie]

You might want to try using Application.Match if you want to find a specific term in a row.

Find will return a reference to the cell that the search term is found in.