Tag Archive | "end"

How To Search For ID Values In A Different Worksheet With Excel VBA

Tuesday, October 4, 2011

0 Comments

This Excel VBA function allows you to take a column of values (e.g. ID numbers) in one worksheet, and use that to get corresponding values that are in a second worksheet. If you understand SQL, it’s something like: SELECT b.country FROM idtable as a, countrytable as b WHERE a.id=b.id I’ll explain the scenario further with [...]

Continue reading...

Difference Between Integer Types in MySQL and Their Max Values

Tuesday, July 12, 2011

0 Comments

In MySQL, there are 5 different integer types, and each type allows for different integer value sizes. In addition, each type can be signed or unsigned. If your value is always positive, then you can make your integer type unsigned. The following are the values that different integer types (signed/unsigned) can hold: Integer Type Start [...]

Continue reading...

How To Remap Keyboard Keys In Windows (Such as the with Apple Keyboard)

Friday, July 2, 2010

28 Comments

I use the Apple bluetooth wireless keyboard, but I use it with my Windows computer, not a Mac. I love it though, and I think it’s the best bluetooth keyboard around – the problem is, while most keys generally work fine, certain keys are missing. For instance, on the Apple keyboard, the command key is [...]

Continue reading...

How To Integrate Your Custom Bit.ly API With Tweet This Plugin

Friday, January 22, 2010

1 Comment

Tweet This is a great plugin that allows you to have “Tweet This” buttons at the end of every post. Not only that, it also allows you to have Digg This, Facebook This, Plurk This, and many other kinds of buttons too. You get about 8 button designs as well, so you can find something [...]

Continue reading...

The Top Thing I love About China is Their Wo Pu

Tuesday, January 19, 2010

0 Comments

Over December, I toured China for a month and saw some pretty interesting things there. And if there’s one thing that I’m thankful for, it’s a travel pillow because the time it takes to fly there can KILL (or land you with a very sore neck). The normal neck pillows don’t cut it too – [...]

Continue reading...