Beginner - Very Simple Code - Type mismatch

[ride5150]

Hi Everyone,

I am writing a VBA macro but am having a type mismatch error. I pulled out the rest of my code, and cannot get this very simple code to run. Not understanding why a whole number cell value cannot be compared with another. I changed the variable type to "Long" and am still having the error.

Private Sub CommandButton1_Click()

Dim j As Integer

Dim k As Integer

j = Cells(26, 5).Value

k = Cells(27, 5).Value

If [j = k] Then

Cells(28, 5).Value = j

End If

End Sub

 

[Scott Huish]

I suspect it's your use of brackets not parentheses [j=k] instead of (j=k) (although you don't need them, you could just say j=k) but if that's all that code is doing, I would just do it in one line:

If Range("E26") = Range("E27") Then Range("E28") = Range("E26")

 

[ride5150]

I suspect it's your use of brackets not parentheses [j=k] instead of (j=k) (although you don't need them, you could just say j=k) but if that's all that code is doing, I would just do it in one line:

If Range("E26") = Range("E27") Then Range("E28") = Range("E26")

that worked, thank you!