remain "+" and remove apostrophe
 

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

remain "+" and remove apostrophe
 

Format the cell/cells as text beforehand.

--
Anything is possible if you don''t know what you''re talking about.


"clara" wrote:

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

remain "+" and remove apostrophe
 

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

remain "+" and remove apostrophe
 

Hi,

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

Clara
--
thank you so much for your help


"Wood Grafing" wrote:

Format the cell/cells as text beforehand.

--
Anything is possible if you don''t know what you''re talking about.


"clara" wrote:

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

remain "+" and remove apostrophe
 

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