Tag Archive | "change"

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...

How To Change Folder Name in Android

Sunday, October 10, 2010

0 Comments

You can create folders to store your shortcuts in your Android phone’s home scree. However, I was trying to change the folder’s name and it took me forever to discover this. Turns out, you need to first open the folder, and long-press on the title bar (it should say “New Folder” at this point). It’ll [...]

Continue reading...

Why I Chose To Switch To Mac OS Over Windows 7?

Sunday, May 23, 2010

3 Comments

So several people have asked me why I made the change to Mac OS, from being a Windows user for over 2 decades. Here’s why: 1. A more functional laptop I wanted a new laptop. I narrowed it down to a Lenovo, Sony or Macbook. 2 years ago, I wouldn’t even consider the Macbook, but [...]

Continue reading...

Edit .htaccess to increase PHP’s max file upload

Tuesday, April 8, 2008

9 Comments

To increase the upload file size limit on your website, you need to edit PHP’s configuration settings. Unfortunately, not everyone has their own web server, so most of the time people are constrained by the limits of shared hosting. But you can still modify your base php.ini file by creating your own php.ini with the [...]

Continue reading...