On Tue, 5 May 2009 05:46:09 -0700, Eric G
wrote:
Actually, that part of your code worked for me, although it shows a "?" and
not the bullet symbol. Perhaps something else in the recorded macro needs
fixing?
This will stick a bullet in your cell:
ActiveCell.FormulaR1C1 = "•"
Thanks Eric... it's a
vb routine and I'm not sure how to set
an Active Cell with that. Jacobs CHRW method is doing the job.
I also had "?" everywhere while testing... and is what Alt-30 gives
you when it won't give you what you want. And where Alt-0151 (em)
or Alt-156(pound) does give you what you want. Ain't computers
marvellous!
Cheers - Kirk