Background:
For the better part of a year I've been developing a vba application.
I've got 48,000 lines of code in about 350 subs and functions in two modules.
I use Rob Bovey's code cleaner about every other day.

I'm not sure if this is possible but I need to make a macro that
searches a column for duplicates.  If it finds a duplicate I need to it
to make it unique by adding a .1 at the end.  I would also want it to
continue to add unique identifiers if there are say 5 duplicates of the

Have a shared workbook with three worksheets - I am trying to see in
cell the last of them that has been changed (and saved) so for th
others to catch up, without waiting the minumum 5 mins allowed in th
tabs.

I have this code in the Worksheet/SheetCalculate event of my excel
sheet which  was created in excel 2000. It works very well. However
when the same worksheet in opened in excel 2002 and a cell value
changed . It does not execute the function as the unprotect worksheet

Hi there, please can anyone help.  Have some VBA calculating a sum from
values in column E.  Got the code from this google group, and have just
about worked out how it works.  However, I don't know how to adapt it
so that it does a sum even if there is only one value to sum.  I

Is there any way to make a macro automatically "follow" changes to the
worksheet itself?
For example, I might have a macro with an instruction such as
   Range("C5") = x

I have a 1-column spreadsheet that contains data in column H.  Some rows in
column H contain no data (i.e., its blank).  I need help in writing a macro
that, starting with cell H2, will examine each cell in column H and
automatically delete a row where no data exists.  The macro ...

Hello! I have a user form in which I read values from text boxes and check
boxes. I then want to store these values in arrays. My code is now written so
that I give values to the arrays directly. However it would be better to loop
this process, a task that I seem to fail since I ...

I'm trying to do something which surely isn't that difficult!
It will be part of a macro in Excel and what I want to do is copy a
range from the activesheet and then paste this into the body of an
Outlook e-mail.Here's the code:

I want to apply conditional formatting across a range of rows accordin
to a date in column D using a For:Next loop. The problem I have i
applying the formula to a given row number in the conditional format.
The conditional format basically changes the colour of a given cell i

Not sure if this belongs here or in outlook questions but please help if you
can.
I am trying to use a macro to automatically send emails (with attachments)
to my customers via outlook. The problems is that i am sending 1 email to

How do I place the cursor in a specific location in a cell (i.e. in between
text) using VBA?

I have a spreadsheet with 33 sheets, the first(sheet1) is blank
except for headings, the second (Cat_id_maker) is a formula page for
generating Category ID numbers
The rest are formula pages that pull info from a Pricelist and arrange

I previously posted:
Somebody must know:
In Excel 2000 I was able to use the following code to add the Autosum
control to a custom toolbar:

I'm trying to adapt a macro by Patrick Malloy MVP, and this is what I now
have.  It's not working.  Wondering if anyone has any suggestions.  
At first try nothing happened.  Then I changed            
With .Range(.Cells(cell.Row, "A"), .Cells(cell.Row, "Z"))