Using wildcard in VBA

[akima]

I want to use the * wildcard in my VBA formula below


For Each ws In WorksheetsIf ws.Name Like Worksheets("CtrlPnl").Range("*G2").Value
Then
ws.Visible = True

however keep getting Run-time Error '1004'

Please help

 

[Joe4]

Can you explain exactly what you are trying to do here?
It is hard to guess what that might be from faulty VBA code.

 

[akima]

I have a value in Cell G2 in a worksheet called CtrlPnl. The value is 26.12 and I want to search the workbook for any sheet name containing 26.12 e.g. Handover.26.12 or WrkLoad.26.12 and then unhide the sheet.

 

[Norie]

Add the wildcard(s) to the value from the cell.

For Each ws In WorksheetsIf ws.Name Like "*" & Worksheets("CtrlPnl").Range("G2").Value & "*"