You can tell it's Friday afternoon - you can just change:
[VBA]CEL Like "[10]"[/VBA]
to:
[VBA]
CEL Like "*10*"[/VBA]
unless you are actually searching for the [] characters too?
You can tell it's Friday afternoon - you can just change:
[VBA]CEL Like "[10]"[/VBA]
to:
[VBA]
CEL Like "*10*"[/VBA]
unless you are actually searching for the [] characters too?
Regards,
Rory
Microsoft MVP - Excel
Posting Permissions
Reply With Quote