Wildcard in VBA

[Shay A]

HI,
I am trying to compare the Activeshee.N s me the the value of specific cell but the code's syntax is not written correctly...
Let's say the Activesheet's name is ABC and the cells value is B:

If ActiveSheet.name= "*"&cells(3,3)&.* then
Msgbox "Partial Math"
End if

Thank you,
Shay

 

[NARAYANK991]

Hi ,

Use the LIKE operator , as in :

If ActiveSheet.Name Like "*" & Cells(3,3).Value & "*" Then

Narayan