View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
L. Howard Kittle L. Howard Kittle is offline
external usenet poster
 
Posts: 698
Default Inserting a character into a cell that has text.

If you have the cursor placed in a cell, it is edit mode and you cannot run
a macro. To run the macro you have to hit Enter to get the cell out of edit
mode but now you are out of the cell. Catch 22!

I have no suggestion, sorry.

Regards,
Howard

wrote in message
ups.com...
I need to read several cells, and occasionally change some by adding
bullets to make the text clearer. For example, the text in the cell
might read:

There are three items here.
An automobile.
The license.
The owner.

I want to bullet this to read:

There are three items here.
. An automobile.
. The license.
. The owner.

I'd like to double click on the cell, place the cursor where I need it,
and press ctrl-A to add (at the cursor) 5 spaces, a bullet, and 2 more
spaces.

Any ideas?
Dom