excel - Dynamically select a cell inside For statement -

excel - Dynamically select a cell inside For statement -

i want dynamically select cell, in column b, within statement.

however get: "application-defined or object-defined error"

how can properly?

for = 1 30 sheets("back").range(cells(i + 3, 2)).select select case activecell.value case "3" sheets("back").cells(i + 3, 2).value = "good" case "8" sheets("back").cells(i + 3, 2).value = "bad" case else sheets("back").cells(i + 3, 2).value = "" end select next

try this:

for = 1 30

sheets("back").cells(i + 3, 2).select select case activecell.value case "3" sheets("back").cells(i + 3, 2).value = "good" case "8" sheets("back").cells(i + 3, 2).value = "bad" case else sheets("back").cells(i + 3, 2).value = "" end select

next i

excel vba