remain "+" and remove apostrophe

[Guest]

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

 

[Guest]

Format the cell/cells as text beforehand.

 

[Bob Umlas]

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

 

[Guest]

Hi,

After I format the cell, it still doesn't work!

Clara

 

[Guest]

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