IF cycle with variables - Error 2015

Hello,

Could you please help me with a strange error, unfortunately I cannot find similar threads with solution.

I have a file where in column F I have a flow of IF formulas which results can be "No updates" or "Updated".

I want to collect each of the items from column A where we have "No updates" in column F.

I wrote the below code to do it, and it works fine sometimes, but sometimes it gives error "Type mismatch" and for the value in Cells(i,6) I have Error 2015 at that time.

Could you please help here?

Thank you in advance!



comma = 0

For i = 5 To lastfxticker



If Cells(i, 6) <> "Updated" Then


fxticker = UCase(Cells(i, 1))

If comma <> 0 Then


listoffxticker = listoffxticker & " , " & fxticker

Else: listoffxticker = fxticker
comma = 1
End If

Else: fxticker = ""
End If

Next

Else: nofxupdate = ""
End If

Hello,
Thank you for coming back to me that quickly.

the formula I use there is a quite long one:

=IF(C5="","",IF(C5="","",IF(AND(E5="T-1",DATEVALUE(C5)=$V$1-1),"Updated",IF(AND(E5="T+1",DATEVALUE(C5)=$V$1+1),"Updated",IF(AND(E5="T",DATEVALUE(C5)=$V$1),"Updated","No updates")))))

and it has a result "No updates", so it should go to my listoffxticker variable, however it doesn't...

I believe the issue should be with the cell(i,6) not using the formula result but the formula instead, no?

Please Login or Register  to view this content.

Solus, thank you for that, however it doesn't solve my issue.

Actually the macro stops at

Please Login or Register  to view this content.

line when it sees that Erorr 2015 in the cell, but cell actually doesn't show any VALUE error, it shows "No updates".

And I run this code on several sheets, having the same format and same functions in all of them and it stops only on two of the sheets, others go nicely.
I tried to delete those sheets and do them again, same result.

I have no idea what goes wrong here.

Thank you for helping

Lovely, it is working now!

thank you very much!

It is done, thank you!