How do I activate this Macro?

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

Any help is greatly appreciated.

Dan

d_kight wrote:
How do I activate this Macro?

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

Any help is greatly appreciated.

Dan

Hi Dan,

Try ALT+F8 and then chose "sigma_to_cell"

It will place a the Sigma in the active cell(s)

Regards,
Bondi

thanks you guys, I will give this a go and see what happens. I am really new
to programming with Macros.

Any suggestions on how to get more training with using and becomming
familiar with visual Basic syntax?

thank you again

"Bondi" wrote:


d_kight wrote:
How do I activate this Macro?

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

Any help is greatly appreciated.

Dan

Hi Dan,

Try ALT+F8 and then chose "sigma_to_cell"

It will place a the Sigma in the active cell(s)

Regards,
Bondi

http://www.mvps.org/dmcritchie/excel/excel.htm
www.cpearson.com
http://www.mcgimpsey.com/index.html

Vaya con Dios,
Chuck, CABGx3



"d_kight" wrote:

thanks you guys, I will give this a go and see what happens. I am really new
to programming with Macros.

Any suggestions on how to get more training with using and becomming
familiar with visual Basic syntax?

thank you again

"Bondi" wrote:


d_kight wrote:
How do I activate this Macro?

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

Any help is greatly appreciated.

Dan

Hi Dan,

Try ALT+F8 and then chose "sigma_to_cell"

It will place a the Sigma in the active cell(s)

Regards,
Bondi

Tools Macro Macros select the macro by name in the large window and
press RUN

Vaya con Dios,
Chuck, CABGx3



"d_kight" wrote:

How do I activate this Macro?

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

Any help is greatly appreciated.

Dan

Something it can also be the macro security.
Go to toolMacrosecurity and set it to medium.


--
Seeking help
------------------------------------------------------------------------
Seeking help's Profile: http://www.excelforum.com/member.php...o&userid=35658
View this thread: http://www.excelforum.com/showthread...hreadid=557019