Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro/Paste Special
Heidi,
Excel is "friendly" in that you can just select a single cell and paste an entire range. Selection.PasteSpecial Paste:=xlValues or Range("A1").PasteSpecial Paste:=xlValues so it doesn't matter if you have copied a single cell or a range of cells. 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 to Paste Special | Excel Programming | |||
Macro to Paste Special | Excel Programming |