I have a list of records in this format
Name 1
Address 1
City 1

I have an Excel calculation sheet. the results of which are
communicated to my clients by way of a letter.   I am using Excel to
generate this letter as all the numbers automatically populate to my
letter worksheet.  Everything looks fine except that I dont like the

How do I create a formula that only brings back the number of days for each
unique Accession number?  For instance, Accession #EH52212995 took 1 day to
process, but there were three different test ran, I only need to know that it
took one day.  HELP.

I am using Office 2003 on Windows XP.
My code dynamically returns certain contiguous columns and certain
continguous rows, say "C:E" and "5:10" for example, in two different
variables as string addresses.

I am exporting a CSV file which allows and end user to save customer
information.  Unfortunately, there are some customer names that have a
comma in the name (ex: Winn Dixie, INC).  How do I export and Import
these names as a .csv while still retaining this info as a single field

Please forgive the repost.  I am hoping the reason for no response was
the lateness of the hour I posted this.  If anyone has some
insight/guidance on this, I would sincerely appreciate it.  Thanks in
advance.

Hi all,
I have attached a spread sheet with a problem. This is the second time
am posting this thread. The last thread did not give me any help. So I
posted this again.  I desperately need you guys help to solve this

I'm using MS Excel 2000, and I want to write a macro that tests cell
contents.  Unfortunately, after a couple hours of looking at help files
(MS Visual Basic 6.0), I have found no method to do so.
My code concept is

I hope someone can help .... Excel 2000
I have a spreadsheet where users need to be able to change values in columns
B:G but not in Column A or H...  
I could lock the necessary cells and protect the sheet, however....

during my practicing I've found:
Code:
--------------------
 Application.MemoryFree

I have a database which is like the folowing (sheet #1):
Column 1 is an index (like SSN)
Column 2 to 27 is data
I would like to make a second sheet which is linked to the first sheet using

HELP PLEASE: trying to compare the result of a cell formula in Cells(A, "C") its contains the result of a Vlookup, I am trying to look for <> with another cell Cells(A, "E") the macro runs once then locks up error code 2042. Anyone any ideas please? Or better code !!!
Sub ...

I have the path of the directory I wish to save to located on Sheet
A1.
I know how to save a file directly but not how to get external dat
from another worksheet. This is what I know how to do.  Would someon

I am attemtping to build custom screen tips for a scatter graph and already
been given some help. However I am stuck again. The following code extract
myX = WorksheetFunction.Index _
                   (.SeriesCollection(Arg1).XValues, Arg2)

I need the code to delete a record/row if cell Q (of that record/row) is
0.  Not empty but 0
What would be the best way to achieve this?
Thanks,