Title says it all. Stepping through the below code does as desire but running the macro doesn't. I am specifically having issues with the Else portion. This is what happens when I run the macro
CountA(Range("B2:B5")) currently equals 3 so goes to Else
Excel pauses for 5 seconds
then image "Dennis" flashes and disappears.
Running in step through (This is what I want)
CountA(Range("B2:B5")) currently equals 3 so goes to Else
Image "Dennis" appears
Excel pauses for 5 seconds
Image "Dennis" disappears
End
Thoughts?
Bookmarks