score:1

you will also want to set it to sheet.range("d20") if you want it to read from the given sheet. otherwise, it will refer to d20 on the first sheet.

if sheet.name = "usa" & i and sheet.range("d20").value = "branch codes" then

Related Query

More Query from same tag