unselect selection
 

Hi,
I am coping and pasting cells via a macro. When it is done the last cells
copied are still selected, the dashed lines around the cell indicating a copy
function. How do I get it to stop selecting the last copied cells. Kind of
like hitting escape on the keyboard?
Thanks,
Ivano

unselect selection
 

Application.CutCopyMode = False
Place this at the end of your macro
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"Ivano" wrote:

Hi,
I am coping and pasting cells via a macro. When it is done the last cells
copied are still selected, the dashed lines around the cell indicating a copy
function. How do I get it to stop selecting the last copied cells. Kind of
like hitting escape on the keyboard?
Thanks,
Ivano

unselect selection
 

worked like a charm... thanks


"Michael" wrote:

Application.CutCopyMode = False
Place this at the end of your macro
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"Ivano" wrote:

Hi,
I am coping and pasting cells via a macro. When it is done the last cells
copied are still selected, the dashed lines around the cell indicating a copy
function. How do I get it to stop selecting the last copied cells. Kind of
like hitting escape on the keyboard?
Thanks,
Ivano