Value on worksheet with fullstop either side

[FIRSTROUNDKO via OfficeKB.com]

Hi all,

Can somebody please tell me how to use the value from the worksheet i.e Cell
F10 to perform the code below

If Cells(nb, 7).Value Like "*.134.*" Then

I would like to replace 134 with any number, but there is a double
complication that the number has a full stop either side of it

Thanks in Advance

 

[Bob Phillips]

Do you mean?

If Cells(nb, 7).Value Like "*." & myNum & ".*" Then


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[FIRSTROUNDKO via OfficeKB.com]

Perfect!

Do you mean?

If Cells(nb, 7).Value Like "*." & myNum & ".*" Then

Hi all,

[quoted text clipped - 7 lines]

Thanks in Advance