Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am using this code (below) and it is giving me an error (Variable not
defined) with the letter A of Serie A highlighted. Any help please? This is the code: Option Explicit Dim nextSecond Sub startFlashing() flashCell End Sub Sub stopFlashing() On Error Resume Next Application.OnTime nextSecond, "flashCell", , False End Sub Sub flashCell() nextSecond = Now + TimeValue("00:00:01") Application.OnTime nextSecond, "flashCell" If Range("AN6").Interior.ColorIndex = 3 Then Serie A.Range("AN6").Interior.ColorIndex = 41 Serie A.Range("AN6").Value = "Light Blue" ElseIf Range("AN6").Interior.ColorIndex = 41 Then Serie A.Range("AN6").Interior.ColorIndex = 3 Serie A.Range("AN6").Value = "Pink" End If If Range("AW6").Interior.ColorIndex = 3 Then Serie A.Range("AW6").Interior.ColorIndex = 41 Serie A.Range("AW6").Value = "Light Blue" ElseIf Range("AW6").Interior.ColorIndex = 41 Then Serie A.Range("AW6").Interior.ColorIndex = 3 Serie A.Range("AW6").Value = "Pink" End If End Sub Thanks for your help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Protect Sheet with code, but then code will not Paste error. How do i get around this. Please read for explainations.... | Excel Programming | |||
OnTime code error "can't execute code in break mode" | Excel Programming | |||
Error in Excel VBA Code (Error 91) | Excel Programming | |||
How can I still go to the error-code after a On Error Goto? | Excel Programming | |||
Code Error - Run Time Error 5 (Disable Cut, Copy & Paste) | Excel Programming |