Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I'm having trouble with the following code. I'm trying to turn on an auto
filter using a value in the range below. From there I'm doing some things, and then I want to come back to the next value in the range, skipping blanks. Dim cell As Range For Each cell In Range("B3:B32") If cell < "" Then Value = Test Range("A1").Select Sheets("WIP Detail").Select 'Turn on Auto Filter & Select Client Number Range("A1").Select Selection.AutoFilter Field:=13, Criteria1:=Test Thanks Vick |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro question | Excel Discussion (Misc queries) | |||
Macro Question | Excel Discussion (Misc queries) | |||
MACRO QUESTION | Excel Discussion (Misc queries) | |||
Macro Question | New Users to Excel | |||
Macro Question | Excel Worksheet Functions |