Automate Paste Special Values

[lexicon59]

Hi-

I'm working on a ticketing spreadsheet with serial numbers in one column
(derived from a formula). When I copy the serial number & paste it, I also
copy the formula. Using paste special and selecting the values option I can
get the serial number to paste into a cell without the formula.

I also need this value to be placed in clipboard memory to I can use the
value in an older windows program.

Is there any way to run a macro, vba, etc. that will do this for me?

Thanks in advance.

 

[Dave Peterson]

I think I'd add the Paste|values icon to my favorite toolbar.

tools|customize|Edit Category
(look for Paste Values)

Then click the copy icon, go to your other cell, click the paste values icon.

And in my simple testing (with notepad), the clipboard still held the value that
was just pasted.

 

[Microsoft]

Thanks Dave, I think this'll work for what I'm doing.