VBA Cut rows and paste values

[viceman57]

I am running the following code to move rows based off of a drop down selection. It is all working fine but it is bringing formulas over to the new sheet with the data.

I want to just bring the values as they are so they stop updating on the new sheet. Is there a paste values I can insert in here?

 

[dreid1011]

Maybe if you change the copy lines like this:

Range("a" & Target.Row).Resize(, 18).Copy
.Cells(.Rows.Count, "a").End(xlUp).Offset(1).PasteSpecial xlPasteValues

 

[viceman57]

Maybe if you change the copy lines like this:

Range("a" & Target.Row).Resize(, 18).Copy
.Cells(.Rows.Count, "a").End(xlUp).Offset(1).PasteSpecial xlPasteValues

This worked! Thanks. just because I like to understand things and I did try this yesterday.

Why does the .cells row need to be moved down a row for this to work?

 

[dreid1011]

This worked! Thanks. just because I like to understand things and I did try this yesterday.

Why does the .cells row need to be moved down a row for this to work?

You're welcome, and happy to help.

If I am not wrong, I believe .PasteSpecial does not work with in-line copy/paste, requiring a new line for the paste.