MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Paste special macro

Posted by glen on November 09, 2001 10:44 PM

There is an operation that I repeatedly have to perform. It is paste special/text. I want to be able to have a macro that after I copy the data in a cell I can point to another cell and click a macro that will allow me to "paste special"/"text".


Posted by John Giles on November 09, 2001 11:20 PM

"paste special"/"text" ? Do you mean PasteSpecial/Values ?
In any event, you can create a macro to do this with the macro recorder. Adjust the recorded code by replacing the receiving cell reference with the word "Selection" (without the quotes).

Posted by Glen on November 10, 2001 2:11 PM


Thank You