I'm working in Excel and trying to program VB to do a function for me.
Let's look at what I've got so far shall we.
Sub DoneWithFlangedRec()
Range("I1").Select
Selection.Copy
Sheets("HCBOM").Select
Selection.AutoFilter Field:=4, Criteria1:= _
Paste("FLG_SEL!I1"), Operator:=xlOr, Criteria2:= _
"= "
Range("D1").Select
Application.CutCopyMode = False
ActiveCell.FormulaR1C1 = "20FL1"
Range("E1").Select
Sheets("HC_HDTHD").Select
End Sub
Obviously the whole paste thing isn't working out to well for me. What I would like to do is take the value in blue up there and paste it into an auto filter for Criteria1.
Any good ideas?
