I am getting an error on the last line of the following:
   Selection.AutoFilter Field:=19, Criteria1:="<>"
   Selection.AutoFilter Field:=1, Criteria1:="1000"
   Selection.AutoFilter Field:=4, Criteria1:="<>1000", Operator:=xlAnd

How can I in VBA select a entire rows("number:number") where the cursor
is active...so when the cursor moves through my for next statement it
keeps on selecting the proper rows that I need it too and skipping the
others?

Dim cell As Range
For *Each cell In Range("B:B")*(...)
Next
I need to modify this call so the cycle goes from B10 to the last ro

Columns A & B contain several thousand Project Numbers (e.g., P1052, PA844,
P6721.6, etc.).  Column A has the latest list of Project Numbers.  Column B
has an older list of Project Numbers.  As such, column B is a subset of
column A.  I need to find all of the “new” (i.e., ...

I have a macro that will create data sheets based upon the mai
worksheets information.
What I was wondering is, upon exiting the file, can I have excel delet
those created sheets so that when the file is opened again the macro ca

If I want to save the value of a "constant", I'd do something like this:
CELLS (i,"A").Value = "=MATCH(""WTD HRS"",""'[""&RC6&""]""&sname""'""'!R7)"
How do I write the results of this as a constant that is not saved in the
workbook.

Dim cell As Range
For Each cell In Range("B:B")
If Len(cell.Value) = 0 Then cell.Offset(0, 1).Interior.Pattern
xlPatternGray8

i am trying to write a goalseek macro with a minimum GoalSeek Goal to
generate premium rates for different ages.
i have a group of people from
age = 17 to 60

Does anyone know how to programmatically change the ListRows property of a
Combo Box?
Using VBA I would like to run a Distinct query against a DB (which I can
do).  That query will return values to a Dynamic Named Range, whose Row Count

We have an Automation Add-In that we developed in C# (2.0) which we are
calling from the worksheet in Excel (2003).  We want to be able to call
functions in that AddIn from VBA code in teh workbook as well.  If it was a
COM Add-IN, we could call

Here is the code with the missing link!
What I want to do is activate a validation list (Named "Comply") in
every cell to the right of a cell containing "I" in the B column...
Anyone knows what goes in the (...)?

ESTIMADOS SEÑORES QUE HAN DISEÑADO EL PROGRAMA DE EXCEL. NO SE SI SEA YO EL
QUE DESCONOCE EL FUNCIONAMIENTO DE EXCEL, PERO NO PUEDO COPIAR UNA CELDA QUE
CONTIENE LA FUNCION DE "BUSCARV" Y PEGARLA HACIA ABAJO EN TODAS LAS CELDAS.
ME DA UN MENSAJE DE ERROR...DESEO SABER CÓMO LE ...

If I want the cells with I:
If cell = "I" Then cell.Offset(0, 2).Interior.Pattern = xlPatternGray8
So How do I refer to Empty cells?
If cell = *EMPTY* Then cell.Offset(0, 2).Interior.Pattern =

i HAVE in cellS:
A1: J234  TELEPHONE
A2: J23456 WASHER
i WANT THESE TO BECOME:

Okay, my macro requires opening two extra workbooks for sorting/copy/pasting
purposes, and I am working on a way to close the extras.  This formula Closes
Workbook 1 which leaves Workbook 2 active, I do a Cells.Select, copy and
activate next which brings up the original workbook, ...