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.

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)

Excel - Concatenate Numeric Text Format

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

Use the following to force Excel to handle your numeric items as you want them to be handled instead of having Excel decide how to handle the conversion of numeric items to text:

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?  

Syndicate content