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?

 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

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

Actually the macro stops at

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

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!