Search EggHeadCafe's Job Board
EggHeadCafe Silverlight WPF ASP.NET VB.NET C# Excel SQL Server SharePoint
search
OfficeArticlesForumsFAQs
Excel
Word
Powerpoint
Outlook
Publisher
Money

MicrosoftArticlesForumsFAQs
C# .NET
VB.NET
Visual Studio .NET
ADO.NET
Xml / Xslt
VB 6.0
.NET CF
GDI+
LINQ
Deployment
Security
FoxPro
Silverlight / WPF
Entity Framework
RIA Services

WebArticlesForumsFAQs
JavaScript
ASP
ASP.NET
WCF

DatabasesArticlesForumsFAQs
SQL Server
Access
Oracle
MySQL
Other Databases

Non-MicrosoftArticlesForumsFAQs
NHibernate
Perl
PHP
Ruby
Java
Linux / Unix
Apple
Open Source

Operating SysArticlesForumsFAQs
Windows 7
Windows Server
Windows Vista
Windows XP
Windows Update
MAC
Linux / UNIX

Server PlatformsArticlesForumsFAQs
BizTalk
Site Server
Exhange Server
IIS

Graphic DesignArticlesForumsFAQs
Macromedia Flash
Adobe PhotoShop
Expression Blend
Expression Design
Expression Web

OtherArticlesForumsFAQs
Lounge
Subversion / CVS
Ask Dr. Dotnetsky
Active Directory
Networking
Uninstall Virus
Job Openings
Product Reviews
Search Engines
Resumes

 
  
Excel Sort Command And Named Range Scramble Prevention
Here's a macro framework that prevents Excel's Sort command from scrambling the addresses of single-cell named ranges located in the sorted range which is a troubling problem mentioned by Microsoft in KB58245.
By Rolf Jaeger on Wednesday, October 21, 2009 8:51:49 PM.
Excel Conditional Hiding Without VBA
Excel macros can do just about anything. But what about those times when you can’t use macros?
By Gary Byrne on Monday, September 21, 2009 9:08:37 PM.
How to get Google Search Results count in Excel?
Everyone who browses internet might have visited "http://www.google.com" atleast once in lifetime. Atleast as of today that is the best search engine available. I know many of the excel users will be curious to play with google search results and excel. So, I will just show you one requirement today and will let you explore the rest. Say, you have a list of values in column A of excel and you want to display the search results count of that list in the corresponding column B. How do you do this?
By sri kot on Thursday, July 09, 2009 12:36:57 AM.
Difference between Worksheets and Sheets Property in Excel
If you are working extensively with all the type of sheets (Worksheets, Charts, Modules / Macro, Dialog sheets) and playing with macros or VBA code then it is very important that you know the difference between Worksheets and Sheets Properties in Excel.
By sri kot on Thursday, July 09, 2009 12:32:43 AM.
Which is Good? Refer Excel Sheets by Index Number or Name
According to Microsoft with respect to sheets, index number is a sequential number assigned to a sheet based on the position of the sheet tab (counting from left) among the sheets of same type. There is a reason for highlight the words "same type" because index number varies depending on the type of property you use for identifying sheets.
By sri kot on Thursday, July 09, 2009 12:28:47 AM.
Excel VBA Macros to get various Counts of a Selection
This is one common scenario that all the excel users encounter everyday. Also, in many forums I have seen repetitive questions on counts of a selection in excel. Just to benefit all those users I have compiled some scenarios related to these counts and explained how to achieve those using macros. So, check the below code blocks, you may find some counts useful
By sri kot on Thursday, July 09, 2009 12:14:18 AM.