I am using the Trial Office 2007.  I have no problems with the other
programs, but when I open Excel 2007 I get the following msg:
MS Visual Basic
Compile Error in Hiidden Module: AutoExecNew

how to sort based on a column  of date that has either dd.mm.yyyy or
dd/mm/yyyy

PLEASE SEND

I have a simple chart set up that references data points which are
vertically ten spaces apart.  The chart has worked fine for months.
However, when I went to update it with another series point today it
simply will not "OK" the extra point.  I click enter, I click okay,

I KNOW you could edit the colors in previous versions of Excel.  You could
even edit the "default" colors (edit then save as template).  But in Excel
2007, I can't find a way to do any of that, and I don't see a single mention
of the ability to do that in the help files or online ...

   I have some code which uses a For Next loop which works very well
with a very large set of 'Regular Expression' statements.
   I'm sure when the code is run, it would be a bit quicker if it
could go back to 'For' when the value of 'valid' is True rather than

I am trying to create a book listing my record/karaoke collection in
Excel, from the file names on my hard drive.
So far, I went to the command prompt in DOS, did a DIR to txt file
listing.

I use column "D" for entering invoice numbers.How can I have Excel lock at
all previous enteries to see if I am duplicating an entry on any other row of
column "D"

is there a way to feed in the the starting cell to begin from when
counting the number of rows?
i can get the below to work in a macro
Dim countRows

I have two ranges of data in two ranges of cells. Basically H4
downwards, and G4 downwards.
The cells typically consists of a list of names seperate by comma's.
So you might have:

Here is what I have in A1 and A2 respectively:
4,5,6,7,8,9
4,5,6
I have this formula in A3 and A4:

Is there a "best way" to quickly identify all Column Headers (perhaps
to Create Names for them in a single step), so that I can paste them
in a separate tab (the list of names will be laid out vertically) and
then hyperlink to them within the table.

I would like to convert a date that I've input from another program.  When I
input it I get 'Aug-28-2008.  I want it to just be a regular date - so it
would be *8/28/2008 if I were to select it in Format Cells.  
It says that I have General as the Category selected.  When I switch ...

I've got a cell with a date that the user types in.  Currently, the
user types a date in and it automatically changes the format to
DDMMMYYYY.
I need the MMM to be in all caps so that it feeds a SQL string

Within my module, I would like to replace the word
      Cells.Replace What:="0", Replacement:="No Spouse",
LookAt:=xlPart _
       , SearchOrder:=xlByRows, MatchCase:=False,