I tried several posted macros for Sentence Case to make every first letter
of every sentence in a cell - Capital one. No success. Every time I get the
same result: #NAME?
Is there any easy way to do that?

Does anyone out there know why my excel program would run slow after a few
minutes.  My cursor sits for a few seconds before it responds to a tab entry.
I can actually see numbers sit for a few seconds and then change after I
make entries.  When I drag my cursor, it seems to ...

I am trying to merge mailing spreadsheets, and the one I am building has
first name & last name columns, but my issue is that many of the other
spreadsheets have only one column for a name (smith, bob). Is there a way to
create a method to use the comma in between the "smith, ...

I have a pivot table set up with 1 page, row and column field with various
values.
Basically, I want to do some math between values of my page variable (i.e.
one value of my page variable is "total" and I want the percentage of that

I want to use a list (column B) to restrict data entries into a spreadsheet.  
However, I want the list to return a value in a different column (column A).  
For example:
BH     Borehole

When using a spreadsheet I change the colour of the font so I can track what
has been done, or what needs to be done.  
Only one issue...
When I change it to red and bold it, the colour changes to blue? And if I

The Design
I have the array formula below which is designed to capture all data entries
between a specific time period (2007), look only at entires entitled "CIC
(column c reference), and further look only at those 2007 CIC entires that

I have a large database with about 6000 rows.  Occasionally, I need to delete
a large number of the rows (5900), and save the remaining data (100 rows) as
a different database.  What is annoying in the smaller database, however, is
that the vertical scroll bar still "behaves" as ...

I have a Validation table on my timesheets that my employees record a
pre-entered activity from a validation table to decribe what they did during
a certain time frame.  From time to time, there will be special exceptions
that the employee needs to enter a value that is not in ...

I need to search for a string of characters in a cell and plave a "1" in
another cell if the string exists, such as:
If the string "HW0" appears I need to put a 1 in adjacent cell
A              B

Hi
I am using Excel 2007 and have installed the Microsoft's  PDF Add-in. I have
also developed my own Add-in which is used by our product to generate
Reports. Everything was working fine till the point the solution was deployed

I'm working on a research project and I have written a program in excel that
is complete except for information that needs to be provided by our
participants.  
My question is, is there a way to link cells in my program document to cells

How can we intrupt Save and Save as in Excel ? I want to write my own code
instead of svaing a document when user clciks on save

I have a macro that uses Autofill to fill a formula down to the last row of
data.  but when there is only 1 single row of data, this error message
appears:
Run-time error '1004'

Why am I seeing filter tabs on empty columns wehn I select AutoFilter??