Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro Question
Thought I would try a new post instead of trying to work on a previous one.
I am using this: Sub temp() Sheets("TMS").Select Selection.AutoFilter Field:=1, Criteria1:=S, Operator:=xlAnd Range("F1").Select Application.CutCopyMode = False Selection.Copy Sheets("CheckNamesSent").Select Range("I4").Select Selection.End(xlDown).Select ActiveCell.Offset(1, 0).Range("A1").Select Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=False End Sub Note that 'Selection.AutoFilter Field:=1, Criteria1:=S, Operator:=xl' the variable S needs definition. I have a list in G6:G8. I need the above code to repeat for each value in this list. Not sure how to do this (as it is important that the "S" value also updates to reflect the next vlaue in the list - G6, G7,G8). 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) |