Excel 2007.  I have code that worked for years with Excel 2003 and now fails
regularly (but not always).  I get the following error:

Run time error '1004'

Hi Bob,
I've incorporated your code successfully, but names are being continuously
added to my list (C12 to C412) from which my worksheet names are being
generated. I'd like to add an error handling event to your code so that the

What should I do if cell A1 is red color and Cell B1 is not negative, Cell C
will show "Cell B should be negative"
Thank you for your help

Two Possible answers to this one that will solve my problem... one from
Excel, one from VBA.
From Excel, is there a formula that will link a cell to a text box value?
-- If the value of "TextBox1" is "Test", is there a way to send this value

I had to change the SQL on an existing query, but the columns came back in
the wrong sequence. So then I deleted the query range (got the warning I was
detelting a query) and built the new query table.  
Now too match up with my VBA I want to rename the query table

Trying to get the VBA command in Excel macro below to add an attachment
in Outlook 2000. The attachment needs to be read from a location in the
Excel file. My friend used the command below but works for Outlook in
XP and not in 2000 it seems.

I am trying to creatre formulas in a macro.  The sheet may have 1 to n
rows.
I am using the match formula to find the difference in two sheets.
The problem I am running into is how to increment the counter  to put

Are there standard checks for errors that the macro's below should have?
An application is being built to be used by others and the following code
works when everything is entered correctly.  I have tried to anticipate some
of the problems caused by individual not using valid ...

I have scanned your posts, and thought I had found the answer to my
problem.  However, when I put this line into my macro, I get an error
message every time.  Help!
I want to print a list that is the output of an "advanced filter"

I am trying to write a macro for my job that will take account numbers from a
computer generated report and compair them with account numbers known to have
problems.  IF working properly, the macro would take the first account number
on the "ActiveWorksheet" and compair it with ...

I have a Macro that runs on Caclulate that looks at a dynamic dataset as well
as a static dataset.  If there is a variance between the two datasets, it
will copy the values of the dynamic dataset and paste them into the static
dataset so that there is no more variance.  

Does anyone know a code or function that will take two numbers seperated by a
comma in a cell and put them in two seperate cells?  For instance taking
85.443,33.45 in a cell and putting 85.443 and 33.45 in two seperate cells.  I
need to do this for a lot of rows. thank you!

Simple question.
Part of my workbook has numbered sheets (1,2, etc. - it has others as well).
I would like to add sheets using a macro, calling them by the next number in
the sequence - eg if the last sheet is 10, the next sheets should be named

I have a subroutine that opens a form which calls other routines. Is there a
simple way to quit all and stop running everything from the called routine?
When the cursor returns to the calling routine I don't want the rest of that
code to run in some situations.  

Am trying to make my Excel 2003 worksheet compatible with Excel 97,
and have already hit the first snag.  The spreadsheet allows users to
virtually "attach" documents to it, which are later sent in the
background as Lotus Notes attachments.  All Excel does is open a file