Macro to insert a symbol

  • Thread starter Thread starter Guest
  • Start date Start date
G

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,
 
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
 
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
 
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.
 
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
 
Back
Top