Tech-karma - tech-karma.com
General Information:
Latest News:
Excel - Create Named Ranges from Column Headers 13 Jun 2011 | 02:42 am
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): read more
Excel - Find and Manage Named Ranges 13 Jun 2011 | 12:42 am
Once you've created and defined named ranges in your Excel spreadsheet, use the Name Manager to find and manage your named ranges. read more
Excel - Show Formulas 12 Jun 2011 | 03:00 am
How to show formulas in Excel instead of the actual formula results. read more
Firefox 4 - Bookmarks on Titlebar on Windows XP 12 Jun 2011 | 02:31 am
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. read more
Excel - Concatenate Numeric Text Format 12 Jun 2011 | 12:00 am
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: read more
Excel - Get Formula for a Cell 12 Jun 2011 | 12:00 am
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) read more
Microsoft Outlook 2007 - Turn off Auto-Preview Attachment 12 Jun 2011 | 12:00 am
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. read ...
SQL Create Column Names as Variable Names 12 Jun 2011 | 12:00 am
Have you ever needed to extracts column names from a table to use as variable names? read more
Excel - Access Named Range in a Function 10 Jun 2011 | 03:00 am
Once you've created named ranges in Excel you may want to access cells within the named range... read more
Playstation welcome back 6 Jun 2011 | 06:50 am
SHARE and FORWARD: In an effort to appease dissatisfaction with the recent hacking and subsequent outage associated with the Playstation Network, Sony is offering some freebies! read more
