Find text in specific cell??
 

Hi,

I'm trying to write some code to determine if a specific cell contains
some text and if the booleen statement is true run the function.

I see the psuedo code something like below but are unsure of the
syntax. The Cell(4,9) actually contains the text "The Street is ..."

if Cell(4, 9) Contains "Street" then

'execute functions'

End if

Thanks

Dewey

Find text in specific cell??
 

Give this a try.

If InStr(cell.Offset(0, -8), "Street") Then
'or using your example
If Instr(Cell(4,9), "Street") Then
'execute functions

--
Best wishes,

Jim


"Dewey" wrote:

Hi,

I'm trying to write some code to determine if a specific cell contains
some text and if the booleen statement is true run the function.

I see the psuedo code something like below but are unsure of the
syntax. The Cell(4,9) actually contains the text "The Street is ..."

if Cell(4, 9) Contains "Street" then

'execute functions'

End if

Thanks

Dewey

Find text in specific cell??
 

Thanks Jim, worked perfectly!

Jim Jackson wrote:

Give this a try.

If InStr(cell.Offset(0, -8), "Street") Then
'or using your example
If Instr(Cell(4,9), "Street") Then
'execute functions

--
Best wishes,

Jim


"Dewey" wrote:

Hi,

I'm trying to write some code to determine if a specific cell contains
some text and if the booleen statement is true run the function.

I see the psuedo code something like below but are unsure of the
syntax. The Cell(4,9) actually contains the text "The Street is ..."

if Cell(4, 9) Contains "Street" then

'execute functions'

End if

Thanks

Dewey

Find text in specific cell??
 

Glad to help.
--
Best wishes,

Jim


"Dewey" wrote:

Thanks Jim, worked perfectly!

Jim Jackson wrote:

Give this a try.

If InStr(cell.Offset(0, -8), "Street") Then
'or using your example
If Instr(Cell(4,9), "Street") Then
'execute functions

--
Best wishes,

Jim


"Dewey" wrote:

Hi,

I'm trying to write some code to determine if a specific cell contains
some text and if the booleen statement is true run the function.

I see the psuedo code something like below but are unsure of the
syntax. The Cell(4,9) actually contains the text "The Street is ..."

if Cell(4, 9) Contains "Street" then

'execute functions'

End if

Thanks

Dewey