Hey everyone,
I am trying to Copy data from one sheet and paste it into another. I want the rows that are hidden to stay hidden when they are being pasted instead of reappearing. I am guessing it is a Paste option, but I don't know which one. Thank you in advance.
Here is my code I am using:
If Range("B16").Value = "Dog" Then
Sheets("Animals").Range("A16:D19").Copy
Sheets("Finished").Activate
lastrow = Range("A65536").End(xlUp).Row
Cells(lastrow + 5, 1).PasteSpecial Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Sheets("Animals").Range("A21:D30").Copy
Sheets("Finished").Activate
lastrow = Range("A65536").End(xlUp).Row
Cells(lastrow + 1, 1).PasteSpecial Operation:=xlNone, SkipBlanks:=False, Transpose:=False
End If
I am trying to Copy data from one sheet and paste it into another. I want the rows that are hidden to stay hidden when they are being pasted instead of reappearing. I am guessing it is a Paste option, but I don't know which one. Thank you in advance.
Here is my code I am using:
If Range("B16").Value = "Dog" Then
Sheets("Animals").Range("A16:D19").Copy
Sheets("Finished").Activate
lastrow = Range("A65536").End(xlUp).Row
Cells(lastrow + 5, 1).PasteSpecial Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Sheets("Animals").Range("A21:D30").Copy
Sheets("Finished").Activate
lastrow = Range("A65536").End(xlUp).Row
Cells(lastrow + 1, 1).PasteSpecial Operation:=xlNone, SkipBlanks:=False, Transpose:=False
End If
Last edited: