Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by Martin King
-
excel 2010 vba help with AutoFilter.range.copy
Brilliant, Thank you to you both. Both methods work exactly as I wanted. As I'm sure its the same for everybody who posts here, hours I spent for something that you two have fixed in seconds. A great Post raised for you both.- Martin King
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
excel 2010 vba help with AutoFilter.range.copy
Hi, I'm looking for some help with the above. I have: Set WSNew = Worksheets.Add(After:=Sheets(ActiveSheet.Index)) (*1) My_Range.AutoFilter Field:=5, Criteria1:="=ARBO" With My_Range.Parent.AutoFilter.range (*2) .Copy Destination:=WSNew.range("A1") End With Now the...- Martin King
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
