automatic Copy/Paste Values Before file save

[Lacaycer]

I'm trying to get my file to execute a copy paste value function anytime someone saves the file.

Copy Range = ("N1:O1")

Paste Range = First open row in Column "L"

[Mumps1]

Maybe:

Please Login or Register  to view this content.

[Lacaycer]

Pasted this into the code for the worksheet tried saving. Nothing happens. What am I missing?

[xladept]

Get rid of that Sub CopyData:

Please Login or Register  to view this content.

[Mumps1]

@xladept: Thank you for picking that up. I initially had the code in a regular sub and then copied it to the Workbook_BeforeSave but I copied one too many lines.

[xladept]

@Mumps1 - You're welcome Maybe you can pick up some of mine

[Mumps1]

They're probably few and far between.

[xladept]

More often than yours(!)

[Lacaycer]

Works....kind of. It isnt pasting values.

Thanks for the help

[xladept]

Maybe:

Please Login or Register  to view this content.

[xladept]

Thanks for the rep!