With Sheets("Search-Results")
If Find285.Offset(0, 10).Value = "1" Or "21" Or "31" Then
Sheets("Search-Results").Range("$I$31").Value = Find285.Offset(0, 10).Value & "st of Each Month" 'Payment Day
Else
If Find285.Offset(0, 10).Value = "2" Or "22" Then
Sheets("Search-Results").Range("$I$31").Value = Find285.Offset(0, 10).Value & "nd of Each Month" 'Payment Day
Else
If Find285.Offset(0, 10).Value = "3" Or "23" Then
Sheets("Search-Results").Range("$I$31").Value = Find285.Offset(0, 10).Value & "rd of Each Month" 'Payment Day
Else
Sheets("Search-Results").Range("$I$31").Value = Find285.Offset(0, 10).Value & "th of Each Month" 'Payment Day
End If
End If
End If
End With
Can anyone tell me why this code is not working? As it's written it applies "st" regardless of what Find285.Offset(0, 10).Value is.
Thanks!
Bookmarks