Donate. I desperately need donations to survive due to my health

Get paid by answering surveys Click here

Click here to donate

Remote/Work from Home jobs

If Or Statement with integer and string?

on

The code below detects the value of 0 in Excel and writes "0 Value" on the powerpoint it's exporting to, but it won't detect and do the same for the string value of "TEST WORDS" in Excel. Instead it continues to write "NOT 0". What could I fix to get rid of the error?

If Sheet1.Range("C" & Row).Value = 0 Or Sheet1.Range("C" & Row).Text = "TEST WORDS" Then
    ppSlide2.AddTextbox(msoTextOrientationHorizontal, 855, 0, 105, 150).TextFrame.TextRange.Text = "0 Value"

Else
    ppSlide2.AddTextbox(msoTextOrientationHorizontal, 855, 0, 105, 150).TextFrame.TextRange.Text = "NOT 0"
End If

Comments

Post a Comment