Unfortunately, I am trying to reverse engineer something, so I need a macro
command that will change #DIV/0 to 0 in all cells with #DIV/0, basically I
need to treat the symptom instead of treating the problem. Thanks for your
help.

We had to reimage a user's computer, and now she is missing an Excel macro
that she had before.  Is there a file that we can pull from her backup to
recover that macro?

I have an issue, a problem with excel and word.
Sometimes word and excel loads very slowly when i start an excel or word
file,  for example, i can go away for a few minutes before its working
correctly. My colleuges dont have the same problem.

I dont know how this happened, but when I view code in vba, the windows for
the code, the "Project Explorer" are all floating around, and they do not
resize, so it is a real pain to navigate around.  I have been trying for a
while to get back to the original setting.

I have several excel workbooks, each with only one sheet used.  Is it
possible to convert these all at once to one workbook with multiple sheets
(one sheet for each orginal workbook)?

Does anyone have any suggestion on how to display month in 2 digits?
For example, MONTH(NOW()) is 5, but I would like to show 05.
Thanks in advance for any suggestions
Eric

I have a file with multiple worksheets 1 work sheet for a summary and the
other worksheets are my quarterly.  In my quarterly worksheets I am always
inserting columns to add P.O. orders to a customer's account, but out to the
end of each customer I keep a total running of their ...

I have a DDE link in the following format:  =TOS|LAST!IBM
This represents a command to go to a broker (TOS) and pickup the last trade
price for IBM.   When I try to convert the function to text and do a
automatic replace of IBM with another stock symbol, such as MSFT, I cannot

I have a spreadsheet for each month of the year to track my reappointment
evaluations, each month I get a list of who is supposed to be reviewed next
month and I type it into my spreadsheet for the given month, my question is I
have a sort indicator that should read "1" in column ...

I need help with an "if" formula. I have a spreadsheet that in column a it
lists the employee's name and then in column b it lists the date the employee
was at work. On a different spreadsheet i have listed a row of scheduled days
of work. I would like to have on this spreadsheet ...

I just did a 'prove it' online excel test, where an interface similar
to excel is presented to the user and the user is asked to perform
certain functions. If you click on a menu item/button that does not
need to be used to achieve the function, then the program interrupts

From the given range whereever the sum exceeds a value say 50K It should stop
and start from the next value. How to get this?????

Hi Ron,
I’m familiar with the Call Function and use it quite often, but that’s what
I’m trying to avoid in this paticular application.  If you run the first
macro and Call the second – you get the send email prompt twice and that’s

I have 2 lists of names and emails, A and B. List A includes list B. Anyone
knows how to separate them quickly. Meaning list A minus list B?

I have a column of data that is very long.  About ever 10 to 15 rows
the column says Parent Sheet 123456 (a six digit random number) then
measurements like 23 X 35.  Sometimes the measurements will be 23 1/8
X 36 1/4.  Is there a way to go through the coloumn and find Parent