Thread: macro question
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
jjnotme[_5_] jjnotme[_5_] is offline
external usenet poster
 
Posts: 3
Default macro question


thanks, it works great.

On Sun, 29 Aug 2010 08:37:29 +0200, "Charlotte E"
wrote:


Add this one-liner to a hotkey combination:

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


CE



"jjnotme" wrote in message
.. .
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?