About Us

Don Guillett[_4_]

glad to help

--
Don Guillett
SalesAid Software

"Graham Daniels" wrote in message
...
Many thanks Don and Tom.

Regards
Graham

"Don Guillett" wrote in message
...
this should do it
Sub Tic1()
With ActiveCell
.Value = "ü"
.Font.Name = "Wingdings"
.Offset(1).Select
End With
End Sub

--
Don Guillett
SalesAid Software

"Graham Daniels" wrote in message
...
This is the code

Sub Tic()
'
' Tic Macro
' Macro recorded 05/09/2004 by Graham
'
' Keyboard Shortcut: Ctrl+r
'
ActiveCell.FormulaR1C1 = "ü"
With ActiveCell.Characters(Start:=1, Length:=1).Font
.Name = "Wingdings"
.FontStyle = "Regular"
.Size = 10
.Strikethrough = False
.Superscript = False
.Subscript = False
.OutlineFont = False
.Shadow = False
.Underline = xlUnderlineStyleNone
.ColorIndex = xlAutomatic
End With
Range("B4").Select
End Sub

Graham

"Graham Daniels" wrote in message
...
Hi,

I wish to record a macro to insert a symbol ( a tick) into the active
cell
and then move down to the next cell in that column. However, when I
try
to
to do this the symbol gets inserted OK but the cursor won't move down
to
the
next cell and it keeps jumping bak up to the original cell. I have
tried
using the relative to cell option on the recording toolbar but no
joy.
Using Excel 2002 SP2

Any thoughts appreciated,

Graham

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Type a symbol useing shortcut keys rather the insert a symbol	RJD	Excel Discussion (Misc queries)	2	December 23rd 09 06:28 PM
Insert symbol	Frank E	Excel Discussion (Misc queries)	3	June 23rd 06 02:47 PM
Macro to insert a symbol	slovak	New Users to Excel	4	May 5th 06 05:06 PM
insert symbol	Santosh	Excel Worksheet Functions	5	May 19th 05 05:31 AM
I need a symbol but "symbol" in the Insert menu is grayed-out.	Nothappy	Excel Discussion (Misc queries)	2	May 3rd 05 12:16 AM