Autofilter

BarrettM · Apr 2nd, 2002, 07:46 AM

I have a worksheet with about 35 columns in use Called Worksheet 'A'. I have autofilter switched on. I can filter this data for views which I then save to another workbook using a macro.

The problem is that I need to be able to select the entire view (no filtered data) using VBA before I import new data into this sheet (Worksheet A).

Can anyone offer any help? If I'm not making this clear enough, I will try to explain further.

kmiles · Apr 2nd, 2002, 08:10 AM

Try this:

Set w = Worksheets("Sheet1")
If w.AutoFilterMode Then
' If autofilter is on, toggle it off to reset
w.Range("Range").AutoFilter
End If

BarrettM · Apr 2nd, 2002, 08:16 AM

Thanks kmiles, works great

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 2nd, 2002, 07:46 AM	#1
BarrettM Board Regular Join Date: Mar 2002 Location: Northern Ireland Posts: 113	I have a worksheet with about 35 columns in use Called Worksheet 'A'. I have autofilter switched on. I can filter this data for views which I then save to another workbook using a macro. The problem is that I need to be able to select the entire view (no filtered data) using VBA before I import new data into this sheet (Worksheet A). Can anyone offer any help? If I'm not making this clear enough, I will try to explain further.

Apr 2nd, 2002, 08:10 AM	#2
kmiles Board Regular Join Date: Apr 2002 Posts: 113	Try this: Set w = Worksheets("Sheet1") If w.AutoFilterMode Then ' If autofilter is on, toggle it off to reset w.Range("Range").AutoFilter End If

Apr 2nd, 2002, 08:16 AM	#3
BarrettM Board Regular Join Date: Mar 2002 Location: Northern Ireland Posts: 113	Thanks kmiles, works great