I have a simple pivot table that refuses to sort certain text items
correctly.  I have tried reformating the cells at the sources, clearing the
cell and re-entering.  Alpha sorts and subtotals work correctly, just the
pivot table is failing to sort correctly.  Any ideas?

Hello  I have two macros, separately they work but when I combined them into
one macro it does not work.  Below is the macro combined.  Thank you for help
Private Sub Worksheet_Change(ByVal Target As Range)
'With Target

I have an excel spreadsheet that for security reasons I want to be able to
have all worksheets in the workbook delete when a certain date in the future
is reached.
does anyone know of a script that would do such a thing???

How do I know if my Workbook is being used / linked by other Wookbook?

At the top of the Excel Worksheet, the E-mail "To" & "CC" boxes are showing.
I do not wish to send this sheet. How can I eliminate the e-mail boxes

Using vs 2007, how can this be modified so that it will colour hidden
columns within the range?
If Target = "F" Then
   With Target.Offset(0, -ColNumber + 1).Resize(1, ColNumber + 15).Interior

Does anyone have any suggestions on how to check the value from a list of
numbers?
For example, there is a list of number under A column, and there is a given
number in cell B1. If I find any number under A column, which match the given

Data as follows:
 A      B      C
ID1  YES  YES
ID2          YES

Does anyone have any suggestions on how to use the function match?
For example, I would like to match the value in cell A1 with a list of cells
in different location.
=match(A1,[C2,F56,H8,J11],0), but the syntax is wrong.

I have a sheet with Column heads
Date             Invoice Number                Amount
I want that in column 4 in any row I have write Paid so this Particualr row
Update with all of its contents on Sheet 2

Hello, I have sheet1 that contains names and addresses. On sheet2 I made a
drop down box to choose any of those names. Is it possible to have the
correct address fill in automatically in the cell next to the one the name is
in ? Thanks for any help, -Kevin

How can I name a range like for E.G. A1:A200 and also C1:C200 and so on
without selecting actually the cells. I want to be able to do it by typing
the range is there a way to do it? Otherwise it would take me very long to
select all the cells I need. Please help.

I am running Excel 2003 and I want to assign a macro to a graphic object on
the worksheet.

How do I add a zero infront of a number.
For example I want the number to be read like this:
012  
But i type in excel it shows up as 12.

How do I will include a graph into a cell like a comment?