Need help on how to search for worksheet name??

[mars91]

Hi all,

I will like to know how to search for worksheet name when using if then function??

What i am trying to do :

If Worksheet("abc") = Table.Cells(2, 2).Value Then

"Table" and "abc" are 2 different worksheets. I am looking on the cells(2,2) on table worksheet. The cells (2,2) have a name of abc. So if that cells is abc then it will search for a worksheet name with abc. Then i can continue with my if then condition.

I just wanting to know is there any search command for searching worksheet name??

Thanks..

 

[mars91]

hi,
ok thank you..