View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
michael.beckinsale michael.beckinsale is offline
external usenet poster
 
Posts: 274
Default Looking for Software - Tick Mark add-in for Excel


Johnny,

Follow these steps. I am using ASAP version 4.0.4

1) Open ASAP utilities
2) Launch
3) Special Characters
4) The default font is 'Lucinda Consol' if you scroll down you
will see what looks like a tick but is actually a square root. Copy and
paste
into a cell in Excel
5) Select the cell
6) Open ASAP
7) Export
8) Export selected chart or range & foolw instructions (I use JPG)
9) The image file is ready for use and can be copy / pasted into cell
or inserted using the following VBA code. Change path / filename to
suit.

ActiveCell.Select
ActiveSheet.Pictures.Insert("D:\Michael\TickMark1. JPG").Select
ActiveCell.Select

Hope this helps.

Let me know how you get on

Regards

Michael Beckinsale