Help with boolean statment for active row

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

exporting specific cell(s)/ range 7
Select first cell in active row? 1
If sheet exists and it is named run this code 4
code help 0
Sum work hours to hours & nearest 10th of an hour 14
Loop Repeats - PLS HELP 2
specifying the column for double click 5
VBA - Copying a Certain Colored Row to Paste in Another Worksheet 1

Back
Top