when making multiple cell selection, it is possible
to add cells to selection by ctrl-click or shift-click.
but what to do, when on long multiple selection i miss one cell
and include not intended one?

Excel 2000.
The conditional formatting does not seem to give a border width choice
I want to use a thick line.
Can this be done?

I have a Vlookup formula which gives me #N/A when the data
is not found.
Is there a way the return is "0" or blank instead of #N/A?
Thank you.

Excel 2000.  This may be too complicated but everything else I have asked in
here has been answered and works great.  I have a column of numbers (column
8).  These numbers are the result of the count function.  I have 70 records.
Some of the counts are 0, some 1, 2, 3, 4, 5, 6.  ...

I have a spreadsheet column with about 4,000 zipcodes extracted from a
mailing list. Many of the zipcodes are multiples. I would like to run some
sort of function to tell me how many instances of each zipcode there are.
I've looked at the "frequency" and "histogram" functions, ...

How do I write formula for numbers in a column and I want the numbers that
equal to and greater than AND equal to and less than. Ex. all numbers in a
column between 20 and 40. Thanks for any help.

Windows XP Professional I'm not shure what version of excel, but I don't
think it matters.

I've got 3,000+ mutual funds as my rows and up to 250 Returns for columns.
The column headers are ReturnDate and the row headers are firm & fund name (two
cols).
Once they get a few columns out and a few funds down, I don't see how the users

I've copied a vertical list of over 1000 customers ID #'s, names and
addresses and pasted the info into column A in Excel.  This info will be
transferred to a letter for each customer.  For this to work effeciently the
customer info needs to be sorted horizontally in specific ...

I have a macro created in VBA that creates two Pivot Tables, one under
the other.  I works fine except I run into problems when the first table
shows up with more rows than I expected when, in the VBA code,  I set
the table destination of the second table.  Then the macro doesn't ...

Is there a way to hide "Excel" when its VB code is running?  Thanks.

I have a column with many numbers that are duplicates.   How can excel help
me get rid of the duplicates with out doing each individual line one at a
time?

How can I effectively do a "save" or "save as" of a workbood from VB.  I
assume there are methods that support this.  Thanks.

Here's the plan:
User highlights a region. For simplicity beginning at A1.
   Suppose region is A1:i34.
User invokes macro IsolateRegion.

I hope I can explaine this well enough. I am using two worksheets
Worksheet 1 is an imported file, worksheet 2 is where all m
calculations are getting done. Sheet 1 column A  and column C are th
only two columns I need to look at. Sheet 2 has the values of what I a