Type 13 Error Mismatch keeps popping up even when code works

August 23, 2018 at 07:20:21
Specs: Windows 10
I am using excel vba but keep getting a Runtime error 13 type mismatch even when my code is still working.


here is the code...
Dim LR1 As Long
Dim j As Long
Dim ws As Worksheet


'Defining the Variables
Set ws = Sheets("Data")
LR1 = ws.Range("H" & ws.Rows.Count).End(xlUp).Row


'Code
For j = LR1 To 1 Step -1
If ws.Range("H" & j).Value = 0 Then ws.Rows(j).EntireRow.Copy _
Destination:=Sheets("Plastic Region").Range("A10000").End(xlUp).Offset(1, 0).EntireRow
Next j

End Sub


See More: Type 13 Error Mismatch keeps popping up even when code works

Reply ↓  Report •

#1
August 23, 2018 at 20:29:04
1 - Please click on the How To link at the bottom of this post and read the instructions on how to post VBA code in this forum. Then please edit your post and post your code based those instructions.

2 - You have told us something about an issue you are having but you have not asked for any help. If you want some assistance, feel free to ask.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code

message edited by DerbyDad03


Reply ↓  Report •
Related Solutions


Ask Question