Spy Journal 3.0 Filtering the web for you

Time to unload the browser again. And I have some great stuff for you all this week. Starting with some geek humour as well as some new toys and news.

Geeks are Sexy post a YouTube video of the Big Bang Theory and Rock, Paper, Scissors, Lizard, Spock, their use of the extended version of Rock, Paper, Scissors. Check it out!

HP has suddenly become an Excel Tips website! These three pages were linked in their last newsletter.

• Go chart crazy with Excel 2007
• Excel tip: make printing easier
• Excel tip: Data entry made easy with AutoFill

Some great news on the Windows Live front.

First of all A note about Hotmail, SkyDrive and Photos storage space from LiveSide advising that there is now a massive 50GB o free space online available to you as follows:

I have had all sorts of problems getting the 8GB of DDR3 RAM  to run in my new Striker II Extreme board. In fact getting the board o run at all has not been easy

It started with CPU INIT errors, and the progressed to BSOD once I got it to POST to BIOS (though couldn’t even get that to happen consistently) and then i started getting CODE INIT errors ( a code that doesn’t even exist in the manual). I gave up and took it back to the shop and they have replaced the board and are attempting to get a stably running system for me. Beyond this blokes skill level! When you read some of these forums below you will se why. So if you have come here looking for answers tot he Asus Striker 2 Extreme Motherboard CPU INIT or CODE INIT errors then read through all these forum links below.

Picture Credit AnandTech Review

I am combining the function of the week with a request I had to write some VBA code to use it. (Note the VBA function is not always the same as the application function).

Here is the question I was asked:

I have two columns - One "AA" and the other "AB"
I want to fill down the column AB based on the results in "AA" but I'm
confused about how to get the individual data from AA2 into AB2 - for
example...
Dim AAcell As Range
Dim ABcell As Range
For Each AAcell In Range("AA:AA")
If IsEmpty(AAcell) Then
    ABcell.Value = ""
Else
    ABcell.Value = Int(AAcell.Value)
End Sub
I'm sure this isnt' right/correct - as it isn't working - LOL - but I'm not
sure how to put it...

Reading this through I understood that the reader wanted to be able to fill a column based on another column. If the first column had a blank cell he wanted that repeated in the new column. All other entries in the new column were to be the INTEGER of the number in the first column. I have provided the code used to make this work at the end of this article. Click Read More to continue.

The last 72 hours have been very intense. My body rhythm is a bit our of whack as a result.

Last week I was working 9:30 or 10:00 AM starts through to around 6PM, breaking for dinner, family, sport, time with Jude, and then recommencing work around 10 or 11PM and working through to 3 or 4 AM before going to bed. This cycle works best for me and my clients both local and international.

However Friday night I worked right though and then went to a clients Saturday all day. By 6PM Saturday night I was cactus and snoozed while babysitting the 3 youngest who had a movie marathon while Jude was out with Miranda at a fancy schmancy ladies thing. When she returned around 9:30 I was half snoozing in the kids bedroom while they were going to sleep. Of course that failed miserably once they heard the door open and their mother come home! Being awake I went back to work until Jude stopped me around 2AM and said “go to bed” in that