I would like to ask if it is possible to extract individual items from
Drop-Down Automatic filter and how (I am total begginer). I have a very
long list (+50.000) of values in column and I would like to get
nonredundant subset. I wrote a Sub() that compares every item in the

day 2 of VBA...
I've managed to create a worksheet ("Summary") containing blocks of
cells separated by empty rows. Now I'm struggling with the next bit.
In the first block, cell A1 contains the title of a chart, B1:Q5

I'm taking my 1st step in learning Excel VBA and I'm confused between
the following :
1. Workbook
2. Project

I have all of my pictures already on the worksheet, and a macro set up to
format the selected picture, it would be great if it would do them all at
once, I could of course manualy select them all, but there are a lot, and
tomorow there might be some more.

I am Basically trying to Find Out the Combinations Covered in a List of
Combinations.
I have a Set of 6 Number Combinations in Cells "G13:L27" ( the Number
of Combinations could be More or Less ).

What is the lifetime of a Public variable?
Does it hold the variableas long as the Workbook remains open?
As long as Excel remains open? Suppose the Public vaiable is declared in
Personal.xls?

Please can someone tell me if it is possible to reference all pictures on a
worksheet from a macro, without having to manualy select each one
individualy beforehand, so that I can simply change the size of them all.
For instance can they ocupy a range?

In an ideal world I would do a 22 nested If statement to check but
unfortunately Excel 2000 will only allow 7.
What I have is a random subset of 5 values from 22 possibilities.
The "english" for the formula is like this:

I have 2 sheets with several fields.
on sheet1, i have new data and on sheet2 i have old data.
i would like to update 2 fields of sheet1 with data from sheet2.
for that i want to compare 3 fields, let's say C, D, E.

I'm trying to send code from a CommandButton2 to Workbook Open. Example:
If Commandbutton2 is "clicked", (which is on a UserForm) then GoTo Workbook
Open() Inputagain: Exit Sub

I can automatically insert the time in the column to the right of one cell
by using Select Case Target Address in the Worksheet Change event by
specifying each individual case.
Is it possible to insert the time in a range of cells that I specify (i.e.

how can i link a a named product with a number .I use certain chemicals with
different density .they are stored in storage bins of the same size ,i would
like to link the product name with its density and create a spread sheet .how
can i link the two so that were ever the product ...

I am trying to save a newly created workbook, using the value of a cell
as its name.
These cell values are used in the first workbook.
[M24] = C:\Documents and Settings\Memos\ 'Pathway for file

----------------------------------------------

----------------------------------------------

Hi,
I am trying update formulas in cells via script. The formula is assigned
correctly, but doesn't work. Instead of value there is #NAME? error tag. But
when I click on formula row in the sheet and pressing Enter - all become