…did you miss me? of course you didn’t, as nobody reads what I post or visits this site. Hey ho.
A while back, WordPress was giving me an error when I tried to hit the site, saying a file, wp-db.php, was missing. I ignored it for a while, and then it started to depress so I set about fixing it. I wasn’t really sure what to do, and after spending some time examining the error logs I worked out the aforementioned file was missing, so I downloaded the latest version of WordPress, acquired an FTP Client and uploaded the missing file.
' 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
If toggle Then
With w.Cells(rowCtr, 2).Interior
.ColorIndex = 6
.Pattern = xlSolid
rowCtr = rowCtr + 1
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. 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.
Click here to find out more.