By default, Paypal really wants to do the foreign exchange for you because they make a few percent off your purchase like most other banks and credit cards. Below I explain the steps required to avoid these fees. In summary, it involves you signing up for a credit card [...]
In this blog post I will explain the steps required to ship your motorcycle overseas yourself, registration and insurance and all that kind of stuff, step by step, it’s not difficult.
In Excel it is much faster to write large sets of data to a spreadsheet all at once instead of using a loop, by copying an array variable to a range of cells directly. This can speed up an Excel macro significantly, especially in large complex workbooks.
In large Excel workbooks when you are executing VB macros that change cells in sheets, you can speed up the process significantly by turning workbook calculations off at the begining of your subroutine, and then back on again at the end. Here are some subs that can do this. Simply call the “Calc_Off” sub at [...]
I’ve tested these in Excel 2010 in sheets with over 16,000 columns and the functions work even for large numbers of columns. Function ColumnLetterToNumber(ColumnLetters As String) As Long ColumnLetterToNumber = Range(ColumnLetters & “1″).Column End Function Function ColumnNumberToLetters(ColumnNumber As Integer) As String Dim strLetters As String strLetters = Cells(1, ColumnNumber).Address(1, 0) ColumnNumberToLetters = Left(strLetters, InStr(1, strLetters, [...]
It’s not usually recommended to use global variables because they make it more difficult for debugging or reading other people’s code. However, they are handy sometimes when you’re in a rush to get your code done. At the top of a Module for example, simply type something like these below. I’ve defined three Pipe Specification [...]
Preserved HTML Editor Markup is your solution, it is a plugin that preserves your custom HTML code. By default WordPress’s TinyMCE will often mess up special HTML tags you use when you switch to the Visual editor even just for a second. Preserved HTML Editor Markup stops this from happening. It is particularly useful [...]
The human body is amazing – it’s as if each cell has a mind of its own. This video from BioChemWeb.org shows a white blood cell (Neutrophil) crawling amung red blood cells, chasing after a bacterium (Staphylococcus aureus).
They poured 10 tonnes of cement for 3 days to fill the tunnels and chambers that make up the incredibly huge structure of a megalopolis ant hill. They excavated the cement skeleton for weeks. The collective minds of millions of small ants created a true wonder of the world.
Once two of the four tires hit sluh and snow in the middle of the road, the result was hydroplaning two wheels out of four, and loss of steering control. The result is graphic.
A 12 year old girl explains how all Canadians are enslaved to the Canadian banking system. Or rather, that the Canadian government is corrupt in that it has given so much power to the monopoly – the banks – which use their power for no good. Worth a watch.
Hot water heaters such as the Kenmore Power Miser 9, come with a plastic drain valve that is most likely going to start leaking soon. Mine started leaking a few months ago through the plug valve washer, but recently the valve sprung a second leak and was leaking right at the threads so [...]
Here is a quick summary of what will be covered in this article, useful for people that own their own small business but do not want to buy specialized financial software: downloading CSV files of your transactions for bank accounts and credit cards, and how to batch concatenate (join) multiples of them together [...]
To watch Netflix and movies on your TV in high definition, I highly recomend the cheap no-name brand Micro USB to HDMI MHL Adapters being sold on Amazon or eBay. The video is full wide screen, and good quality. You can even show your friends how good you are at Angry Birds [...]
There are so many options when looking for offline GPS navigation on Andriod phones such as my Samsung Galaxy SII. There are at least a dozen free navigation apps that use some form of the OpenStreetMap maps (OSM). I wanted to be able to use my phone as a GPS device without [...]
If you want to have the highest chances of getting an item at the best deal, you have to be the first person to see the deal. Problem is, people are very busy these days and don’t want to be bothered spending hours and hours checking online sites like ebay, kijiji, craigslist, autotrader, cycletrader or [...]
Often an ebay seller can block you from sending messages, and you can’t contact the ebay seller. You get a message that says “We’re sorry we couldn’t find an answer for you. Unfortunately, this seller is not able to respond to your question. We suggest reviewing the item again to see if your [...]
Packing too much when traveling is bad, it can limit your options for what you are able to do on a trip because of limited luggage space on a bike. I’ve compiled some packing lists below for the light traveler.
Also check out my blog post on how to [...]
Posts by Category
