Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Code Documentation
I was looking for documentation that would assist in understanding the full implications of the following code: Range("AQ5").Select Range("AQ5:AR25").AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Range _ ("AQ3:AR4"), CopyToRange:=Range("BA5:BB5"), Unique:=False From the way the code seems to work I understand most of the code except the implications and syntax options for the Action: and unique designations. Also for some reason the code is not working in an application where it was working once before so I'm wondering what types of issues might cause that type of code to result in errors. Also, the code is being used to finalize consolidation summary data in a manor similar to the SQL sum by type function. Is there a xls method to do that? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Code Documentation
I was looking for documentation
I'd suggest on line help. Click on "AdvancedFilter" in the code and press F1. -- Jim "Jeff" wrote in message ... | | I was looking for documentation that would assist in understanding the full | implications of the following code: | | Range("AQ5").Select | Range("AQ5:AR25").AdvancedFilter Action:=xlFilterCopy, | CriteriaRange:=Range _ | ("AQ3:AR4"), CopyToRange:=Range("BA5:BB5"), Unique:=False | | From the way the code seems to work I understand most of the code except the | implications and syntax options for the Action: and unique designations. | Also for some reason the code is not working in an application where it was | working once before so I'm wondering what types of issues might cause that | type of code to result in errors. | | Also, the code is being used to finalize consolidation summary data in a | manor similar to the SQL sum by type function. Is there a xls method to do | that? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Microsoft Excel 11.0 Object Library documentation? | Charts and Charting in Excel | |||
Convert a Number Code to a Text Code | Excel Discussion (Misc queries) | |||
MsQuery Documentation | Excel Discussion (Misc queries) | |||
copying vba code to a standard code module | Excel Discussion (Misc queries) | |||
WorksheetFunction Documentation | Excel Worksheet Functions |