I am trying to use the Solver function and have trouble to get the
constraints set up properly.  Of the 4 constraints only 2 are used as I can
tell by the result as well as by looking at the Solver Parameter window in
which only constraints 2 and 4 are listed.  Changing for ...

I have data validation set up to equal text six characters long. Now, I need
to make sure that all values entered are unique. The characters will always
be six numbers, but must be unique from any other six numbers in the column.
Thanks

quite some time ago, I read some comments in this group about Excel's
RAND() function, saying that it was "awful". Is this true, and if so,
why?
Because of speed?

I am new to VBA code for excel, and here is my situation. I have
written a macro and the last part of my macro is to check for the
following:
I have a range of cells I have selected,  and I need to look throughout

Hi all,
I have a Mail Sub to send emails to suppliers with attached orders;
Code:
--------------------

I am trying to write a quick macro to insert the content of a specific cell
from a 1 column array.
I am not sure of the syntax when you use an existing function in a macro,
which probably explain

I have a form that states in 1 row a total number of hours a person
worked on a day.  Above this row i have a row where i place the date of
the certain day this person worked these hours( with TODAY()).
example:

Is there a way to reset a validation list to "blank" or for example the first
choice in the list in a macro?
Thanks.

hi i got a sheet which I copy and insert it at the end of the workboo
problem is that I have a rectangle which I would like text to be insid
however it changes names as soon as I copy it is there a way I could us
like a variable to do what I want with the only shape on my sheet.

Can anybody help me with the next problem.
I have an Excel file wich is like folowing :
  A        B
Name 1  problem1

I have a spreadsheet:
A1 = "Year"
A2 down through A150 has values 1900 through 2050.
AB1 = "Thanksgiving"

The following code should grab policy number from cell B from the
activeworksheet, then go through a recordset (that is a SQL table) to
find that recordset.
However, the following code is always returning EOF even though I am

I would like to know how to establish the list that can be picked
from.. If I "right click" on a cell I get the option to "pick from a
list" but nowhere can I find out how to make that list.

I have a folder that contains about 100 workbooks and these workbooks have to
always be there.
What I do now is go to that folder copy all the workbooks and then past them
into a folder on my desktop.

I have a new item worksheet set up, for buyers to properly enter all of the
information needed to set up new sku's in our system. What I would like to
do, is have them enter the number of new items they are setting up, and then
have Excel copy all of the formulas in row 2 and ...