Skype: Multiple Skype Accounts on Same Computer

Many of us use Skype have more than one Skype accounts. The common situation is that we have one for private use and one for work.

With Skype we can use multiple accounts at the same computer - though it's not an obvious thing how. Here's the tip for Windows:

Start a new instance of Skype:
Start -> Run, type "C:\Program Files\Skype\Phone\Skype.exe" /secondary" and click OK.

Log in with your other account to the new Skype instance and you're done!

VBA: Deleting Rows Programmatically

When you need to delete rows in your spreadsheet programmatically, start from the last row and head towards the first one. This can be accomplished by using Step -1 in the For loop, see example below:


For lRow = lLastRow To lFirstRow Step -1
    ActiveSheet.Rows(lRow).Delete
Next lRow


If we would loop starting from the first row, our lRow counter would be pointing incorrectly at the moment when a first row gets deleted.

Excel Shortcut: Select Entire Worksheet / Select All Data

If worksheet contains data, Ctrl + A selects the current region. To select entire worksheet press Ctrl + A a second time.

Excel Shortcut: Select Entire Row

To select the entire row in Excel, select cell in that row and press Shift + Space

Excel Shortcut: Select Entire Column

To select the entire column in Excel, select cell in that column and press Ctrl + Space

Excel Shortcut: Open VBA Editor

To quickly open VBA Editor window press Alt + F11

Excel Shortcut: Insert Comment or Edit Existing

To insert a new comment or to edit an existing one, select the cell and press Shift + F2