| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter code and assigning Criteria1 equal to value of workshee
Hi,
How can I assign the "Criteria1" parameter below to the value of the worksheet name? The value for the worksheet is always changing. I've assigned this value to "Worksheet.Name". Below is the code and the "Criteria1" parameter that I need to assign to the Worksheet.Name value. Selection.AutoFilter Field:=1, Criteria1:="=242310400", Operator:=xlAnd Application.CutCopyMode = False Thanks in advance! -- Kent Lysell Financial Consultant Ottawa, Ontario W: 613.948-9557 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting based on an equal value in another workshee | New Users to Excel | |||
| toggle between autofilter Criteria1:= "*" and "all" | Excel Programming | |||
| VB Question - AutoFilter related - 'Criteria1:' secion of my code | Excel Programming | |||
| Autofilter - formatting criteria1 data for valid comparison | Excel Programming | |||
| can I use a cell content as a Criteria1 reference in the below Selection.AutoFilter statement? | Excel Programming | |||
Hybrid Mode
