How can I code the same in VBA-Excel?

Well, where you would normally search for a text string you would instead
use something like:

Cells.Find ActiveSheet.Name

I imagine this isn't a huge help to you but it's hard to do more based on
your message. If you post your code maybe we can be more specific.


--
Jim Rech
Excel MVP