Spy Journal 3.0 Filtering the web for you

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

Time to close some tabs. Here are all the good things found since the last round up.

I completely redesigned the front end of www.rasita.biz using panels and views. What do you think? Judith is now selling reptiles as well as her cooking eCourses.

Sarah Perez posted this on live mesh wallpapers. We got them!

Are you Mesh-obsessed? Well now you can show off your devotion to the new service by displaying the Mesh logo on your computer’s desktop. You can grab the zip file for yourself from here.

Sarah also has a Q&A session on Microsoft Office Web Applications.

What is Photosynth:

Photosynth automatically stitches together your digital photographs to create a three-dimensional image.
It’s sort of like a still movie, perhaps. It’s just one object or location captured, but rather than being limited to capturing it in one photograph, you can take many photographs and capture the whole thing in detailed photos, and then they’re stitched together by Photosynth and you are then able to experience your photos in a very creative and fascinating way. You are able to move around, as if you were turning your head to see more of what’s around you, and zoom in as if you were moving closer towards something. It’s difficult to explain, so I would highly recommend you view some Synths created by others already. I have included some incredible Synths in this article below.

A wonderful thing about Photosynth is that you can download and install it for free. All you need is your Windows Live ID and you’re good to go.

How to use it: