ExcelBanter - Autofilter based on user inputbox

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Autofilter based on user inputbox (https://www.excelbanter.com/excel-programming/444561-re-autofilter-based-user-inputbox.html)

Steve[_4_]

Autofilter based on user inputbox

Thanks Garry!

On Friday, May 6, 2011 2:18:31 PM UTC-6, GS wrote:
Also, I forgot to backspace out the dot when I pasted
'RngToFilter.EntireColumn' in your 'With wksSource' construct. So these
2 lines should read...

RngToFilter.EntireColumn.AutoFilter Field:=1, Criteria1:="Y"
and...
RngToFilter.EntireColumn.AutoFilter

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

GS[_2_]

Autofilter based on user inputbox

Steve formulated the question :
Thanks Garry!

You're welcome! Glad to help...

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

All times are GMT +1. The time now is 07:39 AM.