I have a list of random numbers in one column.  Some of these numbers are
repeat numbers.  Is there a way of automatically counting the numbers of
times each number appears in the list

Dave,
Do you know of a way to protect an excel workbook from modifications by
macros?  
Example:

I want to copy formulas without changing the cell references and not
relative without the $ signs.
Example: In C1 I have =A1+B1 (actually mine is complex). I want to copy it
as =A1+B1 to D1 D2 D3 (and many more) is there a clever way to do this.

I have a problem with VBA. When I open my spreadsheet and call a VBA
procedure that calls an optimization software (called Xpress-MP), I get
an error linked to the execution of the model in XPress-MP.
I found an intriguing way of solving my problem: by just using the "save

I have opened a comma delimited .txt file into excel
I need to save it as a tab delimited text file
when I open it in dos editor, the data is not aligned properly.  I have some
of columnA data in ColumnB etc.  Is there a maximum width?  My longest data

I have a form that I need to create that will take information from the
previous months form and paste it into this months form in the correct
colum....  automatically..  or run a little routine.....  I need it so the
user doesn't have to know how to manipulate excel too much.....

I inadvertently created a couple of custom menus for macros and need to know
the steps to eliminate them from the toolbar.  Thanks in advance for any
direction on this matter.  Brad

   Is it possible to create a conditional formatting condition that
can detect the condition of #VALUE! ? That is NOT the text string but
the "error condition". What I am trying to highlight is that certain
calculated values have not been correctly calculated on the sheet and

hi, i have two questions.
1) there is something you can select in excel so that when you writ
really long numbers it treats it as text and doesn't truncate it or pu
it scientific notation. I was wondering what exactly the menu was an

I know how to convert .txt file to excel spreadsheet, but how do you
get EXEL spreadsheet to a .txt file ?
Thanx in advance

I have an Access Database linked to an Excel Worksheet.  In my attempt
to massage the data, I changed their refernces from Right 2 character
to DatePart.  Now I consistently am getting a Numeric Overflow error?
Can someone explain this

I have a spreadsheet with 2 worksheets in it.  I would like to add
hyperlink on the 1st sheet that, when selected will open the secon
worksheet and only highlight certain cells with a large list of info.
The range of these cells could vary, so I can't use a set range o

Could anyone please help.  I am relatively new to Excel and am trying to
design a question paper where the student has to fill in the answer box.
What I would like to do is to only display the first question when the
spreadsheet is opened.  Once the student fills in the answer to ...

I have a large Access database (20000 records of 30 fields each) whic
has been imported from Paradox.
Periodically I need to export this to Excel and have long ago given u
on the 2 standard exporting techniques supplied: 1. File: Export and 2

i have a list of about 10000 products that I'm trying to make a repor
on, They are in excel and can easily be cut and pasted to a ne
location, I am using crystal reports for the report and the repor
requires me to take these products and list them in a way that th