| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro Question
I'm using this macro:
Range("A2").Select Selection.Copy Sheets("TMS").Select Range("Y2").Select Selection.AutoFilter Field:=23, Criteria1:="=BOX074", Operator:=xlAnd Range("F1").Select Sheets("CheckNamesSent").Select I am trying to have the "A2" copy inserted into the Criteria1: Is it possible ? Thank you in advance. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Macro Question
Don't use Copy
Dim s as String .. .. .. s="=" & Range("A2").Value .. .. .. Selection.AutoFilter Field:=23, Criteria1:= s, Operator:=xlAnd -- Gary's Student "carl" wrote: I'm using this macro: Range("A2").Select Selection.Copy Sheets("TMS").Select Range("Y2").Select Selection.AutoFilter Field:=23, Criteria1:="=BOX074", Operator:=xlAnd Range("F1").Select Sheets("CheckNamesSent").Select I am trying to have the "A2" copy inserted into the Criteria1: Is it possible ? Thank you in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro Question | Excel Worksheet Functions | |||
| Macro question | Excel Worksheet Functions | |||
| Excel Macro Question | Excel Worksheet Functions | |||
| using a macro question revisited | Excel Discussion (Misc queries) | |||
| Closing File Error | Excel Discussion (Misc queries) | |||
Hybrid Mode
