macro question

[jjnotme]

I have text in a cell which reads xxx (the text can be anything). I
want to press a key and add a space and "< 10,000" to the cell
How do I do that?

 

[Charlotte E]

Add this one-liner to a hotkey combination:

ActiveCell.Value = ActiveCell.Value & " < 10,000"


CE

 

[jjnotme]

thanks, it works great.

Add this one-liner to a hotkey combination:

ActiveCell.Value = ActiveCell.Value & " < 10,000"


CE