Help with boolean statment for active row
 

On a given active row, what is the boolean statement to perform the following:

if cell "H" for a given row contains "i" then Sheets("Report").Range("B1") =
"Yes"


again... I'm new to this and need some basic guidance.

Help with boolean statment for active row
 

givenrow = 2
if Instr(1,cells(givenrow,"H"),"i",vbTextCompare) then
Sheets("Report").Range("B1") = "Yes"
End if

If you mean the value of the entire cell is the 1 characters string "i"

If cells(givenrow,"H) = "i" then
Sheets("Report").Range("B1") = "Yes"
End if

--
Regards,
Tom Ogilvy


"TexWolf" wrote:

On a given active row, what is the boolean statement to perform the following:

if cell "H" for a given row contains "i" then Sheets("Report").Range("B1") =
"Yes"


again... I'm new to this and need some basic guidance.