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