Thread: Value on worksheet with fullstop either side
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
FIRSTROUNDKO via OfficeKB.com FIRSTROUNDKO via OfficeKB.com is offline
external usenet poster
  
Posts: 65
Default 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

Reply With QuoteReply With Quote