VBA amendment to paste values only?

Hi Guys,

This is my first post and I'm not really sure how to go about copying the VBA code so it actually looks like code as I see on other posts but here's the crux of it;

I am currently using a "Private Sub Worksheet_Change(ByVal Target As Range)" to automatically move the data in a column on sheet 1 to sheet to based on a drop down selection.

The code works perfect only I have now realised that I could do with it pasting the data as special paste values only...

Does anyone have any suggestions of how to edit this 'copy paste' coding to make it paste values only?


Range("A" & Target.Row & ":K" & Target.Row).Copy Sheets("Sheet2").Range("A" & LrowCompleted + 1)


Any help would be much appreciated!

Thanks

Neil

Hi & welcome to the board
How about

Please Login or Register  to view this content.

Thanks Fluff!

That worked perfect

How do I mark this thread as closed?

You're welcome & thanks for the feedback.

To mark as solved, click on "Thread Tools" above the first post.