Value on worksheet with fullstop either side

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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200608/1

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" <u15639@uwe> wrote in message
news:65184d2f20d6e@uwe...
> 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
>
> --
> Message posted via OfficeKB.com
> http://www.officekb.com/Uwe/Forums.a...mming/200608/1
>

Perfect!

Bob Phillips wrote:
>Do you mean?
>
>If Cells(nb, 7).Value Like "*." & myNum & ".*" Then
>
>> Hi all,
>>
>[quoted text clipped - 7 lines]
>>
>> Thanks in Advance

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200608/1