Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Manual Autofilter works, but recorded Macro does something else
Still failing to move from newbie status and my kitchen table, I have a
question on autofilter: I am using Excel 2003 and I am trying to Autofilter a table. I wrote the code manually and did not get it to work. Then I did the operation manually and recorded a macro without problem, but when I run the macro, no data is visible. I want all rows that have "SANT" in column 5 and "User Needs Document" in column 18 to show which in this case is eight (when I do it manually). This is the recorded macro code: Range("H4").Select Selection.AutoFilter Selection.AutoFilter Field:=5, Criteria1:="SANT" ActiveWindow.ScrollColumn = 5 ActiveWindow.ScrollColumn = 6 ' some more of the same to get to the right hand column ActiveWindow.ScrollColumn = 15 Selection.AutoFilter Field:=18, Criteria1:="User Needs Document" End Sub When recording, this results in 8 data posts, when running the macro with exactly the same conditions (as far as I can tell), the autofilter does not return any visible rows. What am I (or Excel :-) doing wrong? Help is greatly appreciated! Peter S |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Manual Autofilter works, but recorded Macro does something else
Sub BBB()
With Range("A1:T50") .AutoFilter Field:=5, _ Criteria1:="SANT" .AutoFilter Field:=18, _ Criteria1:="User Needs Document" End With End Sub worked fine for me. Change A1:T50 to reflect your data range. -- Regards, Tom Ogilvy "Peters" wrote: Still failing to move from newbie status and my kitchen table, I have a question on autofilter: I am using Excel 2003 and I am trying to Autofilter a table. I wrote the code manually and did not get it to work. Then I did the operation manually and recorded a macro without problem, but when I run the macro, no data is visible. I want all rows that have "SANT" in column 5 and "User Needs Document" in column 18 to show which in this case is eight (when I do it manually). This is the recorded macro code: Range("H4").Select Selection.AutoFilter Selection.AutoFilter Field:=5, Criteria1:="SANT" ActiveWindow.ScrollColumn = 5 ActiveWindow.ScrollColumn = 6 ' some more of the same to get to the right hand column ActiveWindow.ScrollColumn = 15 Selection.AutoFilter Field:=18, Criteria1:="User Needs Document" End Sub When recording, this results in 8 data posts, when running the macro with exactly the same conditions (as far as I can tell), the autofilter does not return any visible rows. What am I (or Excel :-) doing wrong? Help is greatly appreciated! Peter S |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Manual Autofilter works, but recorded Macro does something els
Finally, success!
Maybe I should have told you that I am running a swedish version of Excel and that "SANT" means "TRUE" in english. When I replace "SANT" with "S", both your's and my code work. I thought about this earlier and checked that the cells format were ordinary text and not boolean, but I must say that Excel acted strange, because when i wrote "TRUE" in my code, "SANT" appeared in the spreadsheet. Well, problem solved. And by the way, my english Office version is waiting at the post office. I will get it tomorrow! Thanks for the inspiration Tom. I think that the ten or so lines of code before this strange autofilter comes from you originally also! I owe you! Peter -- -------- Peter Sebelius "Tom Ogilvy" wrote: Sub BBB() With Range("A1:T50") .AutoFilter Field:=5, _ Criteria1:="SANT" .AutoFilter Field:=18, _ Criteria1:="User Needs Document" End With End Sub worked fine for me. Change A1:T50 to reflect your data range. -- Regards, Tom Ogilvy "Peters" wrote: Still failing to move from newbie status and my kitchen table, I have a question on autofilter: I am using Excel 2003 and I am trying to Autofilter a table. I wrote the code manually and did not get it to work. Then I did the operation manually and recorded a macro without problem, but when I run the macro, no data is visible. I want all rows that have "SANT" in column 5 and "User Needs Document" in column 18 to show which in this case is eight (when I do it manually). This is the recorded macro code: Range("H4").Select Selection.AutoFilter Selection.AutoFilter Field:=5, Criteria1:="SANT" ActiveWindow.ScrollColumn = 5 ActiveWindow.ScrollColumn = 6 ' some more of the same to get to the right hand column ActiveWindow.ScrollColumn = 15 Selection.AutoFilter Field:=18, Criteria1:="User Needs Document" End Sub When recording, this results in 8 data posts, when running the macro with exactly the same conditions (as far as I can tell), the autofilter does not return any visible rows. What am I (or Excel :-) doing wrong? Help is greatly appreciated! Peter S |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
autofilter problem in Mac, but works in Windows, Excel 2003 | Excel Discussion (Misc queries) | |||
Manual AutoFilter - Vlookup, Index, Match, Array??? | Excel Worksheet Functions | |||
RECORDED MACRO PASTE'S DATE DIFFERENTLY TO MANUAL PASTE | Excel Worksheet Functions | |||
Autofilter works... just not in my ListBox_click! | Excel Programming |