Macro to insert a symbol

[Guest]

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

 

[Pete_UK]

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.

Pete

 

[Pete_UK]

I 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.

Pete

 

[Guest]

Pete_UK is correct.

If you still want a VBA solution, then consider:

Sub sigma_to_cell()
Selection.Font.Name = "Symbol"
Selection.Value = "S"
End Sub


This will sigma-fy all the cells you have selected.

 

[Guest]

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