= ChrW(9650)
= ChrW(9660)

If this post helps click Yes
---------------
Jacob Skaria


"kirkm" wrote:


How do you put the bullet Character (Alt 30) into a cell with code?

I recorded a macro and ended with

Range("T1").Select
ActiveCell.FormulaR1C1 = "?"

but running this invokes
Run-time error '1004':
Select method of Range class failed

1 hour + Googling and still looking !

Thanks - Kirk