Hi Bob,

Thank you very much. Your method works well when the code is in a regular
module, but it doesn't work well in a sheet module, so I have to use
activecell.value = '+ to assign + to a cell, but the ' will appear also if I
don't click other cells.

Clara

thank you so much for your help


"Bob Umlas" wrote:

Activecell.Value="+" will not put a ' in the cell. Check to see if you have
Tools/Options/Transition/Transition Navigation Keys checked.

"clara" wrote in message
...
Hi all,

In vba, I assign '+ to a range , but the ' also is also displayed. Could
you
tell me how to remove ' and remain +

Clara
--
thank you so much for your help