Hi, I have data that I export from Proclarity to Excel monthly.  After I do
this, I'd like to run a macro that compares data in column A & B to data in A
& B for the next row.  If data in EITHER A or B are different, I'd like to
Insert 2 new rows and insert the sum for that group ...

Can I put the last modified time and date into a header in Excel 2003?
If so, how would I do that?
Thank you in advance.

We use JD Edwards World as our accounting & payroll system, and spend a lot
of time re-keying information from hardcopies of forms (e.g. “Employee Setup
Information Form”) into various screens in JD Edwards (via iSeries Access for
Windows).

Somehow (god only knows), I did something so that when I use the roller in
the center of my mouse, it now zooms in and out on sheets instead of
scrolling up or down.  I believe this is "toggling" and it's driving me crazy
and I don't know how to remove this "setting".  PLEASE ...

My boss just updated my slow old computer with a fast new
computer...with Vista operating system.  We immediately checked out
our visual basic code written under windows 2000, and the macros are
behaving differently.  What I need to know is if we just need to

I have a working If function that says, IF(A>B, A-C+D, E), and I want
to add an additional intruction to this that states that IF(B=0, E, 0)
as opposed to it defaulting to the "A-C+D" calculation. How can I add
this additional funtion to the current function. I think it has

I have tried the code below, but it does not seem to work. Some times I get
a type mismatch on the first "IF" statement, then other times it will show
the first two msgbox.
What I am trying to do is to test for different column changes, and then

I have an excel file and macro that fills in a form for each employee.
The forms fills in the individual's data and the form prints. The macro
selects the next employee fills in the form and prints. This continues until
the last employee is printed.  Is there a way to print as one ...

I've got a spreadsheet with a few checkboxes.  If a user checks one, I want
them to be able to edit specific cells.  If they uncheck it, I want the
values they've entered zeroed out and the cells to be protected.
I can accomplish the second piece by unprotecting the sheet, zeroing ...

Hash tables are eminently useful structures and I found one for VBA
(http://www.devx.com/vb2themax/Tip/19307) that I'm trying to use.  I
have it mostly working but not quite completely.  The instructions
say:

In creating a price list, I am looking for a way for a cell to read another
cell and determine if the number in that cell is between one number and
another.  Depending on the range, I want to assign that cell a letter.  For
ex:

I would like to protect those created macros in my MS Excel file so that
other can't modify them as described below:-
when one goes to Tools > Macro > Macros.....; after he selected a particular
macro, once he clicked on the Edit button, a dialog box will pop-up to ask

I am not quite sure if I did it right or there is something wrong with
the DCOUNTA function.  Basically, I want to count the number of cells
that contains the letter "c" and "c" only (as the whole value in the
cell).  A screen shot is provided at this link:  http://www.f12f ...

Hello, I am very unfamiliar with programming VB and Macros in excel.
Here is the situation.
I would like to have a check or an "X" appear in a cell when it is
double clicked.

Instead of using outlook calendar alert, I have set up a macro in excel to
email me when I run the macro. Please see below.
I have a formula in a worksheet, which when negative indicates that I need
to physically do something manuel in my life (i.e. T-bills have matured, Time