Does anybody have, or are smart enough to write, an excel macro that will
produce random numbers WITHOUT duplicates. I can't see to get my head around
this problem

Is there any way to divide all cell in a work sheet by 1000?

can someone help me?
x    0
x    0
x    1

In the "City" column, we type city with capital case in order to identify
the donors.  Now I need to mass mailing to the donors only. Is there any
possibilty that I can filter all cities typed with "cpital case"?
Thanks in advance for your help!

I need to make a separate worksheet for each State, which I can do, but within each one of the State worksheets I need a separate worksheet for each month.  So I can tab through the information for each month for each State.  Essentially, when I click on a State, a new set of ...

Hello, I would immensely appreciate it if somebody could help me wit
this urgent problem I have.
A person who drafted a previous document put company info in a vertica
manner instead of a horizontal matter.  For instance, this worker pu

Does anyone know how to change the colour of text in one cell depending on
the value of another?
For example:
I want the word 'pig' in cell A1 to be red if the value of A2 is negative

I can't seem to get an & in my excel header. It
disappears.
Can anyone help me.
Shauna

i am new to excel and i would like to have it resize the cells automatically
to the size of the text i entered. i know if i click on a cell and do format -
line break it does it for one cell. but how can i have excel do this
automatically for every cell in every workbook?

When I double-click a .csv file, Excel opens, but the .csv-file doesn'
open correctly. Excel doesn't see the comma's as delimiters. I don'
even get the 'text-import wizzard' to ask me how I want to open th
file.

this formula worked up to yesterday. i had a power surg and now it onl
give me one color.
Private Sub LCase(Target.Val Target As Range)
Dim myColor As Long

I need to be able to provide a user with a text window for them to typ
in information in Excel.  The challenge is that I understand that ther
is a 256 char limit.  I have to build the Excel doc to work in Exce
2000.

How to do formatting of unlocked cells?
I have locked certain cells and wish the user to have freedom o
formatting other (unlocked) cells. But once the sheet is protected
formatting etc. are not possible even for unlocked cells.

I am using the following formula to count the number of times an entry
appears in a list :
=COUNTIF('Full Output'!J:J,"Outlook Edition")
the problem is, there are entries such as "Outlook Edition" but there can

From what I've seen being asked on these forums this question sound
like n00bish. But is it possible to check that certan cells are fille
in and if they are not an error message pops up. I am planning to use
macro if its possible and put this into a print sheet button, so firs