Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro/Paste Special
Heidi,
Forgot to mention that you can Customize your toolbar and add a ready-made PasteSpecialValues button. This way your users can use the toolbar button to copy a cell or range, select another (single) cell and paste values with a quick click. steve "Heidi Harting-Rex" wrote in message ... Hello, Some users complain that when they copy data Excel also copies the borders of the selected cells. They want to be able to simply copy and paste text within a worksheet. Is the best way to do this with a macro? If so: I am wishing to write a macro that would take whatever has been copied to the clipboard (i.e., this is determined by the user at that instance) and does a Paste Special/values. How can I tell the macro to just look for whatever is in the clipboard, or has been copied, rather than it looking for a fixed range? THANK YOU SINCERELY. All of the best to you today, Heidi Harting-Rex |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cut & Paste Need Special Macro | Excel Discussion (Misc queries) | |||
PASTE SPECIAL w/ Macro | Excel Discussion (Misc queries) | |||
Paste Special in a macro | Excel Worksheet Functions | |||
Macro/Paste Special | Excel Programming | |||
Macro to Paste Special | Excel Programming |