software

I am trying to write a mini macro to insert the sum symbol as text in a cell.
In the macro, I record quot;insert, symbolquot;, double-click the sum symbol, click
quot;insertquot;, clickquot;closequot;,enter, then quot;stop recordingquot;.
The sum symbol correctly displays when the macro is created, but when I run
it again it always displays a quot;?quot;.
I know that I must be making a very simple mistake here...can someone save
me from my stupidity?
Thanks,

Using the Character Map (in System Tools), the Sigma character is
available as U 03A3 on the numeric keypad. This might be an alternative
way of getting the character into your sheet - it looks like * S * on
these newsgroups - you might want to embolden it and increase the font
size.

Hope this helps.

PeteI put the sigma character between the asterisks, and it looked fine as
I typed in the response above, but obviously it only displays here as
an S.

PetePete_UK is correct.

If you still want a VBA solution, then consider:

Sub sigma_to_cell()
Selection.Font.Name = quot;Symbolquot;
Selection.Value = quot;Squot;
End SubThis will sigma-fy all the cells you have selected.
--
Gary's Studentquot;slovakquot; wrote:

gt; I am trying to write a mini macro to insert the sum symbol as text in a cell.
gt; In the macro, I record quot;insert, symbolquot;, double-click the sum symbol, click
gt; quot;insertquot;, clickquot;closequot;,enter, then quot;stop recordingquot;.
gt; The sum symbol correctly displays when the macro is created, but when I run
gt; it again it always displays a quot;?quot;.
gt; I know that I must be making a very simple mistake here...can someone save
gt; me from my stupidity?
gt; Thanks,

Pete, Thank you for your response, but before I could try your method someone
suggested that I include the symbol in a blank workbook and set my macro to
access that workbook, select the cell containing the symbol, copy and paste
special into my destination workbook. This worked.
Thanks again.
slovak

quot;Pete_UKquot; wrote:

gt; Using the Character Map (in System Tools), the Sigma character is
gt; available as U 03A3 on the numeric keypad. This might be an alternative
gt; way of getting the character into your sheet - it looks like * S * on
gt; these newsgroups - you might want to embolden it and increase the font
gt; size.
gt;
gt; Hope this helps.
gt;
gt; Pete
gt;
gt;