Saturday, November 08, 2008

Dual Boot - Windows Woes

I've still not found the right drivers to make WindowsXP connect to Internet. All my attempts end up like this -

funny pictures of cats with captions
more animals

Thursday, November 06, 2008

Dual Boot - Xubuntu and Windows

Yay! Fixed wireless issue on new install.

OS wasn't detecting my Thinkpad's wireless card on both Ubuntu 8.04 and Xubuntu 8.04. I was having a hard time but thanks to wonderful Ubuntu community I was able to fix them. I'm still struggling to fix it on Windows :-)

Here is the tip that ticked -
http://ubuntuforums.org/showthread.php?t=826233&highlight=aironet

Saturday, October 25, 2008

Hot air ballooning in Seattle

This birthday I did hot air ballooning 3000 ft above Snohomish County of Seattle. The clear sky enhanced the pleasure.



Hot air balloon works on a simple principle that hot air is lighter than surrounding cold air. This difference causes balloon to rise. First manned hot air balloon was invented by the French and in their honor, the organizers always celebrate success of a flight with Champagne.


Here is the link to the ballooning website - http://www.airialballoon.com/

Labor of Love



June 29, 2008. I ran my first ever half marathon!

Well I did not just run but walked, dragged and cribbed. 13 miles did not seem easier when I registered for the run and boy! were they any easier.

My friend and I planned to train for several months in advance and started just in time a week before the run. Training made us confident of running at least 3 miles which is just enough to cross Seattle's 520 bridge (2.3 miles long) on foot. It was the first time ever the bridge was being opened to pedestrians.

But when we had crossed the bridge and taken a piece of rubber tire as memento, we decided to try finishing the run.

Volunteers after every mile greeted and cheered us. There were high school children offering water and glucose, people watering plants giving free shower and another group of people applauding our efforts.

5 1/2 hours of continuous and painstaking walking got me two nice event Tees and the above medal. Later I received bruised toes and strained shin too but I was told those were exclusives :)



A portion of each registration fee went to the Floyd and Dolores Jones Cancer Institute at Virginia Mason Medical Center.

related: http://theruchi.blogspot.com/2008/05/half-marathon.html

Wednesday, August 27, 2008

Get Last Used Row

Sub get_last_used_row()
' to get the last non-blank row

LastRow1 = Cells(Cells.Rows.Count, "A").End(xlUp).Row
'this is the keyboard equivalent of selecting a range using shift and down arrow
'   Exercise What does "A" signify??

LastRow2 = UsedRange.Rows.Count

MsgBox "LastRow1 " & LastRow1
MsgBox "LastRow2 " & LastRow2

End Sub

Exercise - What is the difference between LastRow1 and LastRow2. Though they might give same results occasionally, the approach to get the last row is different. Find it out!


Tuesday, August 26, 2008

selcells

Sub selcells()
' this sub shows how to get a cell value
ActiveSheet.Select
cellval = Cells(1, "A")
MsgBox cellval
End Sub

Try writing a sub that copies value of A1 into B1 without use of an intermediate variable.

Monday, August 25, 2008

Msgbox Inputbox

Open excel
Do Alt F11
Paste -

Sub pgmhello()

MsgBox "Hello"
' accept name from user
name1 = InputBox("Name Please")

' concatenate hello and user name
MsgBox "Hello" & name1

End Sub

Click green triangular button or PF5

Try it!