View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Olórin Olórin is offline
external usenet poster
 
Posts: 3
Default REQ Help with simple Excel macro

Thanks, but "always I7" isn't a huge improvement on "always D7"... or am I
missing something?

"Les Stout" wrote in message
...
Hi Olórin, hope this helps... ;0)
This will leave the cursor where it is but change the values of "I7"

Sub Tick()
'
Range("I7") = "ü"
With Range("I7").Font
.Name = "Wingdings"
.Size = 10
.Strikethrough = False
.Superscript = False
.Subscript = False
.OutlineFont = False
.Shadow = False
.Underline = xlUnderlineStyleNone
.ColorIndex = xlAutomatic
.Bold = True
End With

End Sub


Best regards,

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***