Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter - storing parameters
Hi All
Is there a method to read and save the parameters of an autofilter? I wish to copy the selection and store the filter values with them, as a scenario for reporting etc. Any idesa welcome Cheers Nigel |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter - storing parameters
Nigel
This may help http://www.nickhodge.co.uk/gui/viewm...m#Custom_Views... The VBA example given has an example of hidden columns but it will work as well with filtered data -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "Nigel" wrote in message ... Hi All Is there a method to read and save the parameters of an autofilter? I wish to copy the selection and store the filter values with them, as a scenario for reporting etc. Any idesa welcome Cheers Nigel |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter - storing parameters
An alternate:
Maybe you can use Bill Manville's post from a couple of years ago: http://groups.google.com/groups?thre...0ADE%40iies.es Nigel wrote: Hi All Is there a method to read and save the parameters of an autofilter? I wish to copy the selection and store the filter values with them, as a scenario for reporting etc. Any idesa welcome Cheers Nigel -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter - storing parameters
Thanks for the tip, a bit of modification and I have cracked it.
It works great. Cheers Nigel "Dave Peterson" wrote in message ... An alternate: Maybe you can use Bill Manville's post from a couple of years ago: http://groups.google.com/groups?thre...0ADE%40iies.es Nigel wrote: Hi All Is there a method to read and save the parameters of an autofilter? I wish to copy the selection and store the filter values with them, as a scenario for reporting etc. Any idesa welcome Cheers Nigel -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
storing macros ? | Excel Discussion (Misc queries) | |||
Storing a value to variable | Excel Discussion (Misc queries) | |||
can custom autofilter pull parameters from other data? | Excel Discussion (Misc queries) | |||
Storing data | New Users to Excel | |||
Storing Macros | Excel Programming |