In Excel you can use the allmighty Visual Basic Editor to create very useful macros. Today I will share with you a macro which deletes a row if it contains some string. The code is
Sub delgoogle()
Dim i As Long
With ActiveSheet.UsedRange
For i = .Row + .Rows.Count – 1 To .Row Step -1
If Cells(i, “A”).Text Like “*google*” Then Rows(i).Delete
Next i
End With
End Sub
What this code does, is look in the sheet where the macro is ran, for a row containing the word google. Note the “*” which means that the row can be …

When you paste or import text that looks like a hyperlink into a cell, the hyperlink does not actually work but remains as a text entry. If you type the same text into a cell by using the keyboard, Microsoft Excel interprets the entry as an active hyperlink.
The cause lies here:
Microsoft Excel does not interpret these text values as hyperlinks unless they are typed from the keyboard.
To convert cells that contain valid hyperlink text in Excel to active hyperlinks, use …

Fixing the Windows 0×80070002 update error by utilizing various methods.

While updating windows, it is possible to receive the 0×80070002 Error. As a result the update process will not be completed, and your computer will not be able to transmit files. The reason for your computer receiving the 0×80070002 Error is due to it not having all of the files that should have been transmitted when updating your software. This is an initialization error that occurs after files have been downloaded, and extracted to the computer.
To fix the error manually, it …

If you must, you can use an iPod as a backup device. The cons may outweigh the pros though, but if you don’t have an external hard drive, it is possible.
Too much activity on your iPod can shorten its lifespan; they are designed to work with small music and video files, not large and weighty files like the ones on your Mac. You would not want to use your iPod as a backup device or to access a disk image unless it was an absolute emergency.
However, if you must use …

Something goes wrong somewhere, and people get the following problems after the installation of Windows Internet Explorer 8:
- In Windows Explorer (I mean those file explorer for browsing folders/files), when you double-click on a folder, a new Windows Explorer is popped up instead of showing the folder in the same explorer.
- In Windows IE8, when you right-click a web address on a web page, and then click [Open in New Window] or [Open in New Tab], the web page cannot be opened in a new window / tab.
- In Windows …

Some specific viruses can be very difficult to remove by standard means. In addition to that can a virus’ payload damage or undermine system stability, computer security and anti-virus software functionality so that it might be best considering the use of a virus removal tool. Cases when virus removal tools came in handy include dealing with acute virus threats and infections for which vendors of anti-virus software had not yet released a solution, using it  as a patch, or, alternatively, fighting acute worm infections of epidemic scale, especially in a …

Yoog is a nasty search engine which replaces the default Google search engine in both Firefox and Internet Explorer. This leads to unwanted popups and ads shown. Yoog can be easiliy removed this way:
Firefox

In the URL address box, type about:config and hit enter.
You may get a message like “here be dragons“. If you do, just click the button that is there.
Then you should see a Filter: box. In the Filter box, type keyword As you type this, items will be filtered from the list showing in the window and only …

Nowadays with large usb drives it is very convenient to bring all your favorite apps on a usb stick and using them without the need to install them over and over again. There is a great software from VMware called ThinApp and it is used for application virtualization solution. As with similar products from other vendors, it is able to execute applications without them being installed in the traditional sense by virtualizing resources such as environment variables, files and Windows Registry keys. The virtual environment presented to the client is …

There are lots of ways you can use the Computer Management Console to protect your PC. For instance, you can use the Event Viewer to view security audits, which can inform you of failed logon attempts, password lockouts, and other security issues. You can view system failures such as failed printing requests, failed connection requests, and similar errors and warnings. Paying close attention to these events can help you uncover security threats like logon attempts that happen when you are not on the PC.
The Users folder (in the computer Management …

A wireless network, unlike a wired network, allow users to work in a more convenient and flexible style while also reducing the costs. Wireless networking offer many benefits but at the same time creates a number of security issues that must be addressed. The same work convenience that makes wireless networking so good can also allow hackers to attack the network easily. By securing the wireless network, you can close many doors for hackers to access the network resources and services. These several ways, if implemented, will create a secure …