Quote:
Originally Posted by et_33
The previous owner has many different cells tied to the specific naming conventions and it would take even longer to go through and change all of the necessary cells, also the cells that need to be copy and pasted must be changed occasionally to reflect new employees and so on... If anyone else has an idea of a vba function at the end of a macro to copy something specific to the clipboard as text please reply!
|
That still doesn't warrant trying to put anything into the clipboard. If the save names occur in particular cells, it's a simple matter to insert those cell names into the save string without involving the clipboard. This can be done with any string you can put into the clipboard. However, since you really haven't told us anything much about what you're trying to achieve - instead of fixating on a particular approach - all we're doing is guessing.