This should be working....after all the head banging, it better be working.
http://66.61.113.104/~navi/~navi.html
Sunday, April 13, 2008
Friday, April 11, 2008
Wednesday, April 09, 2008
You better know what this is...
...coz if you don't, you should not be part of mankind (hint hint!).
Wednesday, March 12, 2008
How to sort Excel cells by color...
Finally figured this one out. Although a workaround, it seems to work fine. This is possible by inserting an extra column in the sheet and then using a user defined function. The function will return a number indicating the colour of the cell used in that particular cell (or row). You can then use the normal (Data > Sort) command using this new column as your first sorting column.
Copy and paste the following code to a new VBA module created in the excel file you are working in:
Option Explicit
Public Function ColourSorting(ByVal rgeCell As Range, _
ByVal bBackGround As Boolean, _
ByVal bText As Boolean) As Integer
If bBackGround = True Then ColourSorting = rgeCell.Interior.ColorIndex
If bText = True Then ColourSorting = rgeCell.Font.ColorIndex
If ColourSorting < coloursorting =" 0"
End Function
Source: http://www.bettersolutions.com/excel/EAK113/QO520032321.htm
More detailed stuff on this site: http://www.cpearson.com/excel/SortByColor.htm
Copy and paste the following code to a new VBA module created in the excel file you are working in:
Option Explicit
Public Function ColourSorting(ByVal rgeCell As Range, _
ByVal bBackGround As Boolean, _
ByVal bText As Boolean) As Integer
If bBackGround = True Then ColourSorting = rgeCell.Interior.ColorIndex
If bText = True Then ColourSorting = rgeCell.Font.ColorIndex
If ColourSorting < coloursorting =" 0"
End Function
Source: http://www.bettersolutions.com/excel/EAK113/QO520032321.htm
More detailed stuff on this site: http://www.cpearson.com/excel/SortByColor.htm
Monday, September 03, 2007
Wednesday, August 01, 2007
India beats England!
Something that has happened only 5 times in the past 75 years, a test victory in England deserves a special mention. A great performance by the team - Zaheer and the openers specially. Tendulkar got it going too, the nasty hit on the helmet notwithstanding. A moment to enjoy - and hope for a series victory.
Here's my grab of the videos - Tendulkar being hit on the grill of the helmet - ouch!
See how his head jerks after being hit by the 90 mph ball!
Ganguly putting a finger in his ears after having being out wrongly.
Tendulkar was moping for a long time after his dismissal, rightly so.
Time for Vaughan to take a break and do some thinking.
Zaheer don't like no candy - no Sir.
Here's my grab of the videos - Tendulkar being hit on the grill of the helmet - ouch!
See how his head jerks after being hit by the 90 mph ball!
Ganguly putting a finger in his ears after having being out wrongly.
Tendulkar was moping for a long time after his dismissal, rightly so.
Time for Vaughan to take a break and do some thinking.
Zaheer don't like no candy - no Sir.
Thursday, July 05, 2007
Graduation Video is up!
Watch mom and dad 'dress' me for my Graduation ceremony - putting my cap on! It was really windy and my Batman gown seems to all over the place. Its Abhijeet shooting the video - it took everyone a while to work the small camcorder. I'm so happy my parents were able to make it the 'Shoe that day! Take a look!
Subscribe to:
Posts (Atom)
