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

Value on worksheet with fullstop either side
 

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

Value on worksheet with fullstop either side
 

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