I have a macro where I select files to open then my macro runs on each file.
It checks cells within a range for the correct data I have everything working except a small part of the code.
If Range("D1").Formula <> "=Latest!C5" Then
ElseIf Range("D1").Formula <> "=Latest!B5" Then
MsgBox "Cell...