Blogs

Excel - Create Named Ranges from Column Headers

Submitted by Tech-Karma on Sun, 06/12/2011 - 08:42

If you've ever wanted to create a series of named ranges from column headers, the following contains code that you'll need to add to the VB Editor in Excel (CTRL+F11):

Excel - Find and Manage Named Ranges

Submitted by Tech-Karma on Sun, 06/12/2011 - 06:42

Once you've created and defined named ranges in your Excel spreadsheet, use the Name Manager to find and manage your named ranges.

Excel - Show Formulas

Submitted by Tech-Karma on Sat, 06/11/2011 - 09:00

How to show formulas in Excel instead of the actual formula results.

Firefox 4 - Bookmarks on Titlebar on Windows XP

Submitted by Tech-Karma on Sat, 06/11/2011 - 08:31

In order to further streamline your latest Firefox 4 install, you can download a plugin for Windows XP that will allow you place your bookmarks toolbar on the windows titlebar.

SQL Create Column Names as Variable Names

Submitted by Tech-Karma on Sat, 06/11/2011 - 06:00

Have you ever needed to extracts column names from a table to use as variable names?  

Microsoft Outlook 2007 - Turn off Auto-Preview Attachment

Submitted by Tech-Karma on Sat, 06/11/2011 - 06:00

If you've been frustrated by Microsoft Outlook 2007's taking several minutes to attempt to "auto-preview" your email attachments, you may want to turn the "auto-preview" attachment feature off.

Excel - Get Formula for a Cell

Submitted by Tech-Karma on Sat, 06/11/2011 - 06:00

In Excel, if you're looking to see the function for a particular cell and not all cells, you can use the following:

Create this function in VB (accessible through CTRL + F11)

Syndicate content