IF-THEN-ELSE not working properly

Hi, this is my first time posting here. I've been searching for a thread that might be helpful for my current issue but could not find one.
these are the lines im having issues with:

Dim FNTotQty As String
          FNTotQty = Workbooks(wb).Worksheets(ws).Range("B43")

   If UCase(FNTotQty) = "QTY" Then
        For TotReb = 2 To z + 1
             Cells(TotReb, 26) = Cells(TotReb, 5) * Cells(TotReb, 6).Value
         Next TotReb
   End If

My goal is if all-caps variable FNTotQty is QTY then it should run the code above but it it is not the case. It does the opposite. If the actual value of FNTotQty <> QTY, the code will run. This is really weird. Help please.

Originally Posted by HaHoBe

Hi, danex,

to me sounds like maybe additional trailing blanks behind the value that you compare in your workbook:

Dim FNTotQty As String
FNTotQty = Workbooks(wb).Worksheets(ws).Range("B43")

If UCase(Trim(FNTotQty)) = "QTY" Then
  For TotReb = 2 To Z + 1
    Cells(TotReb, 26) = Cells(TotReb, 5) * Cells(TotReb, 6).Value
  Next TotReb
End If

Ciao,
Holger

hi holger, i double-checked it. no trailing blanks.

hi all.

thanks for the response. I was probably just pretty overwhelmed with all the programming languages i wanted to learn. I realized I was pointing to the wrong worksheet. the ws in Workbooks(wb).Worksheets(ws).Range("B43") should not have been ws.

By the way, how do I close this thread?