Title:
MrExcel's Learn Excel #839 - Filter by Selection
Video:
Description:Shawn sends in a great tip for today's podcast. Access has a Filter by Selection icon. Using a few lines of VBA code, you can add this functionality to your personal macro workbook. Episode 839 shows you how. Here is the code: Sub Filter_by_Active_Cell() Dim ColNum As Integer ColNum = ActiveCell.Column - _ (ActiveCell.CurrentRegion.Column - 1) Selection.AutoFilter Field:=ColNum, Criteria1:=ActiveCell End Sub Sub AutoFilterToggle() Selection.AutoFilter End Sub This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
Published:
08/Jan/2009
MrExcel's Learn Excel #839 - Filter by Selection
Video:
Description:Shawn sends in a great tip for today's podcast. Access has a Filter by Selection icon. Using a few lines of VBA code, you can add this functionality to your personal macro workbook. Episode 839 shows you how. Here is the code: Sub Filter_by_Active_Cell() Dim ColNum As Integer ColNum = ActiveCell.Column - _ (ActiveCell.CurrentRegion.Column - 1) Selection.AutoFilter Field:=ColNum, Criteria1:=ActiveCell End Sub Sub AutoFilterToggle() Selection.AutoFilter End Sub This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
Published:
08/Jan/2009
No comments:
Post a Comment