Deleting blue paste area
Gord
That doesn't do anything with the destination sheet for me. It removes
the running ants around the source range, but nothing else. The blue in the
destination range is still there. Am I missing something? Thanks for your
time. Otto
"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Otto
How about Application.CutCopyMode = False
Gord Dibben MS Excel MVP
On Tue, 10 Oct 2006 16:31:53 -0400, "Otto Moehrbach"
wrote:
Excel XP & Win XP
I am operating within a 'With ws/End With' construct, where ws is a
worksheet. I copy a range from somewhere else and paste it to ws. My
copy
paste commands a
ThisRange.copy
.ThisCell.PasteSpecial xlPasteValues
When the code is through and I manually select sheet ws, I see that the
paste range is still all blue from the paste action. I can take all the
blue out by simply selecting any cell, of course. But my question is:
Can
I get rid of the blue in the paste range of ws by code, after the paste
command, without selecting ws and selecting a cell?
Thanks for your time. Otto
|