Posted to microsoft.public.excel.programming

GS[_2_]

external usenet poster

Posts: 3,514

Autofilter based on user inputbox

Try...

With wksSource
.Activate
.RngToFilter.EntireColumn.AutoFilter Field:=1, Criteria1:="Y"
.UsedRange.Select: Selection.Copy
With wksTarget.Range("1:1")
.PasteSpecial Paste:=xlPasteColumnWidths
.PasteSpecial Paste:=xlPasteValues
End With
.RngToFilter.EntireColumn.AutoFilter
End With

--
Garry

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Autofilter based on user inputbox	Steve[_4_]	Excel Programming	1	May 10th 11 01:01 AM
Autofilter based on user input?	Randy	Excel Programming	0	February 28th 07 10:52 PM
user difined inputbox	Brian Matlack[_36_]	Excel Programming	2	December 15th 05 08:04 PM
allow user to change workbook while in Msgbox or InputBox	[email protected]	Excel Programming	1	March 22nd 05 02:33 AM

All times are GMT +1. The time now is 06:39 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us