Hey guys, first of all, thanks for reading.

I want to be able to search for a string in a cell. For example,

The content and location of the cell is 'Storage(PCI-X)' and
cells(1,1)

and I would like to search to see if the content contains PCI-X

can I do

with .range(cells(1,1))
set c = .find('PCI-X', LookIn:=xlValues, lookat:=xlWhole)

if c = true
blahblah
else
blah blah


Thanks!

-Tom


--
Etrnal168
------------------------------------------------------------------------
Etrnal168's Profile: http://www.excelforum.com/member.php...o&userid=25135
View this thread: http://www.excelforum.com/showthread...hreadid=492343

Take a look at instr in VBA's help.

dim myStr as string
mystr = Worksheets("sheet1").Range("A1").Value
If InStr(1, mystr, "PCI-X", vbTextCompare) > 0 Then
'found it
Else
'nope
end if

Etrnal168 wrote:
>
> Hey guys, first of all, thanks for reading.
>
> I want to be able to search for a string in a cell. For example,
>
> The content and location of the cell is 'Storage(PCI-X)' and
> cells(1,1)
>
> and I would like to search to see if the content contains PCI-X
>
> can I do
>
> with .range(cells(1,1))
> set c = .find('PCI-X', LookIn:=xlValues, lookat:=xlWhole)
>
> if c = true
> blahblah
> else
> blah blah
>
> Thanks!
>
> -Tom
>
> --
> Etrnal168
> ------------------------------------------------------------------------
> Etrnal168's Profile: http://www.excelforum.com/member.php...o&userid=25135
> View this thread: http://www.excelforum.com/showthread...hreadid=492343

--

Dave Peterson

Etrnal168 Wrote:
> Hey guys, first of all, thanks for reading.
>
> I want to be able to search for a string in a cell. For example,
>
> The content and location of the cell is 'Storage(PCI-X)' and
> cells(1,1)
>
> and I would like to search to see if the content contains PCI-X
>
> can I do
>
> with .range(cells(1,1))
> set c = .find('PCI-X', LookIn:=xlValues, lookat:=xlWhole)
>
> if c = true
> blahblah
> else
> blah blah
>
>
> Thanks!
>
> -Tom

The formula

=NOT(ISERROR(SEARCH(\"PCI-X\",A1)

will let you know if the string "PCI-X" is in Cell A1.

From here, you can use "if c = true, blahblah else blah blah" but you
have to convert it to the ff Excel syntax, i.e.,

=if(condition or argument,value if argument is true,value if argument
is false)

Hope this helps ...


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=492343

Thank you guys sooo much!

-Thoma

--
Etrnal16
-----------------------------------------------------------------------
Etrnal168's Profile: http://www.excelforum.com/member.php...fo&userid=2513
View this thread: http://www.excelforum.com/showthread.php?threadid=49234

Etrnal168 Wrote:
> Thank you guys sooo much!
>
> -Thomas

Thank you for the feedback.

Regards.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=492343