Archive
Excel Macro: colour alternate ranges of the same value in the specified column
'
' Process a column of values, colouring alternate ranges of the same value.
'
' Work down a column of cells, stopping when a blank is hit.
'
' If a cell is a different value to the one preceding it, invert the
' value of the toggle variable.
'
' If the toggle variable is true colour the cell.
'
Public Sub main()
Dim w As Worksheet
Set w = Worksheets("Sheet1")
Dim rowCtr As Integer
rowCtr = 2
Dim toggle As Boolean
toggle = False
While w.Cells(rowCtr, 1).Value <> ""
If rowCtr > 2 Then
If w.Cells(rowCtr, 2).Value <> w.Cells(rowCtr - 1, 2).Value Then
toggle = Not toggle
End If
End If
If toggle Then
With w.Cells(rowCtr, 2).Interior
.ColorIndex = 6
.Pattern = xlSolid
End With
End If
rowCtr = rowCtr + 1
Wend
End Sub
Your App’s Website Sucks
Why has this movie not been made?
…a fictional 2006 FIFA World Cup Finale between Germany and Netherlands. When the team from Germany loses, they send out as revenge a Zombie invasion
Why? God dammnit why?
The Dunning–Kruger effect, and it explains a lot……
The definition of the Dunning-Kruger effect, aken from Wikipedia:
…is a cognitive bias in which “people reach erroneous conclusions and make unfortunate choices but their incompetence robs them of the metacognitive ability to realize it”…
Which can be summarised as:
The trouble with the world is that the stupid are cocksure and the intelligent are full of doubt.
This explains a lot, don’t you think?
Homeopathy is an ancient, pre-scientific and absurd pseudoscience
Homeopathy is an ancient, pre-scientific and absurd pseudoscience. Yet it persists today as an accepted complementary medicine, largely because people don’t know what it is.
The 10:23 Campaign aims to show the public what homeopathy is and explain how we know it doesn’t work.
The Apollo Hoax Promoters
The most interesting, not to mention entertaining, proponents of the Apollo Hoax theory are:
- Bill Kaysing – the “father” of the Apollo hoax theory.
- Ralph Rene – conspiracy theorist and ardent hoax supporter.
- David Percy and Mary Bennet
- Marcus Allen
- Bart Sibrel – conspiracy theorist, ardent hoax supporter and film maker. He was famously punched by Buzz Aldrin after accusing the astronaut as being “a coward, a liar and a thief” – see the youtube video here.


