If or statement

lgross

New Member
Joined
Jan 25, 2014
Messages
24
Sub
For i = 1 to lastrow

If Cells(i, 4).Value = "Income" Or Cells(i, 4).Value = "Expense" Then
Range("A" & i, "G" & i).Copy
Sheets("Trial WorkSheet").Select
Range("A1").Select
lastrow = Range("A1000000").End(xlUp).Row
ActiveCell.Offset(lastrow, 0).Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("General Journal").Select

End If
Next i

Application.ScreenUpdating = True
End Sub
The If Statement doesn’t work correctly the code move the Income data but doesn’t move the Expenses data.
What is wrong with the code?
Thank you
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
I see an inconsistency in your stated problem. Is it "Expense" or "Expenses"?
Note sure if it just a typo in your question, or that is what is causing the issue.

If that isn't it, please post a small sample of what your data looks like.
 
Upvote 0

Forum statistics

Threads
1,223,911
Messages
6,175,323
Members
452,635
Latest member
laura12345

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top