Wednesday, January 27, 2010
Wednesday, January 13, 2010
I set up Memepedia as an experiment to see what can be build to index ideas. Just as wikipedia attempts to set up an authoritative encyclopedia, I thought it should at least be possible to set up the same type of thing, but for ideas.
Wikipedia limits the discussion to facts... there are often many aspects of things related to an idea. There are proponents, opponents, criticism, and many other valuable things to be added, all of which are pretty much absent from Wikipedia.
I've had a bit of a learning curve to get it up and running, but even so, the investment is fairly trivial. I don't expect to make any money off of this, but I would like to see the idea take off.
Friday, January 08, 2010
I've recently had some trouble with Excel sheets containing empty, but spurious text boxes. They would show up as unwanted random lines disrupting output. Copy and paste the code below into the VBA editor, it will make each of the text boxes 20x20 pixels which should make them big enough to spot and remove.
Dim shp As Shape
Dim sLoc As String
For Each shp In ActiveSheet.Shapes
If (.Type = msoTextBox) Then
If .Width < 2 Then
.Width = 20
.Height = 20
If you want, you could also just delete them... uncomment out the .Delete statement by removing the leading ' mark.