How do I unselect a cell in a macro
 

The cells that you copy when you want to paste data into another location.
After you copy cells, a moving border appears around them to indicate that
they've been copied.
In my macro I copy the value at a cell and paste to a child sheet.....the
copied cell continues to have the moving boarder..Is there a command in VAB
to deselect to shut off the moving border ????
Thanks for any help
Chris

How do I unselect a cell in a macro
 

Application.CutCopyMode = False

"cgnotrom" wrote:

The cells that you copy when you want to paste data into another location.
After you copy cells, a moving border appears around them to indicate that
they've been copied.
In my macro I copy the value at a cell and paste to a child sheet.....the
copied cell continues to have the moving boarder..Is there a command in VAB
to deselect to shut off the moving border ????
Thanks for any help
Chris

How do I unselect a cell in a macro
 

Thankyou so much. I have been searching for this for a week now. Just didnt
know how to ask the f1 file for the proper responce.
Thanks again.
Chris

"Sean Timmons" wrote:

Application.CutCopyMode = False

"cgnotrom" wrote:

The cells that you copy when you want to paste data into another location.
After you copy cells, a moving border appears around them to indicate that
they've been copied.
In my macro I copy the value at a cell and paste to a child sheet.....the
copied cell continues to have the moving boarder..Is there a command in VAB
to deselect to shut off the moving border ????
Thanks for any help
Chris