Assigning A Cell A Value

[SandraF]

I am trying to assign the value Y to a row (iRow) after I import that information to another worksheet. (made a macro).

I use the following code to assign the field a Y value:
ws.Cells(iRow, 9).Value = "Y"

The problem is that it assigns the Y to the right place during the execution of the macro, but when the macro is finished running, there is no Y in the field.

Do you know how to make the Y stay permanent in the field.

The reason I need it to is because i later check for the Y (in the same macro) and don't want to import that information again if there is a Y in that field.

THANKS