Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with range and autofilter
Private Sub CommandButton1_Click() ActiveWorkbook.RefreshAll With Worksheets("Findings") .DisplayPageBreaks = False Worksheets("EstFindings").Range("a1:b1").AutoFilte r _ Field:=2, _ Criteria1:="=0.01" .DisplayPageBreaks = True End With End Sub Excel 2002 This macro is running off of a button on Worksheet1. What I'm trying to do is refresh my PivotTables*then* place an custom AutoFilter on columns A and B of my worksheet named "findings" that sorts by items greater than 0%. When I run the macro, I get an error stating the Range selection method failed. Thoughts? -- BigDave ------------------------------------------------------------------------ BigDave's Profile: http://www.excelforum.com/member.php...fo&userid=7741 View this thread: http://www.excelforum.com/showthread...hreadid=387751 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with range and autofilter
Hi
Instead of A1:B1, try A:B "BigDave" wrote: Private Sub CommandButton1_Click() ActiveWorkbook.RefreshAll With Worksheets("Findings") .DisplayPageBreaks = False Worksheets("EstFindings").Range("a1:b1").AutoFilte r _ Field:=2, _ Criteria1:="=0.01" .DisplayPageBreaks = True End With End Sub Excel 2002 This macro is running off of a button on Worksheet1. What I'm trying to do is refresh my PivotTables*then* place an custom AutoFilter on columns A and B of my worksheet named "findings" that sorts by items greater than 0%. When I run the macro, I get an error stating the Range selection method failed. Thoughts? -- BigDave ------------------------------------------------------------------------ BigDave's Profile: http://www.excelforum.com/member.php...fo&userid=7741 View this thread: http://www.excelforum.com/showthread...hreadid=387751 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autofilter problem | Excel Discussion (Misc queries) | |||
PROBLEM WITH AUTOFILTER | New Users to Excel | |||
What is Range For Chart AutoFilter Range VBA? | Excel Discussion (Misc queries) | |||
autofilter problem | Excel Worksheet Functions | |||
Autofilter with Range problem | Excel Programming |