Deselecting a cell in macro

  • Thread starter Thread starter Brad E
  • Start date Start date
B

Brad E

The last actions in my macro are copying a cell, pasting
the value to another cell, then selecting a new cell so
the active cell is where it should be after the macro.
The cell I copied remains with the "running border"
because my copy command was never really finished (I only
copied values). Is there a way to essentially hit the Esc
key before I finish the macro?

TIA, Brad E.
 
Brad, try this Application.CutCopyMode = False
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **
 
Back
Top