About Us

dizzl3e

thanks!! that did the trick..

"Jef Gorbach" wrote in message
...
The below suggestion uses autofilter to only show those rows where
column(M) is nonblank, then copy all
of the visible rows to your destination. You didn't specify,so I
showed how to page it on sheet2 starting at cell A1.

sub filtercopy()
Cells.AutoFilter Field:=13, Criteria1:="<"
Cells.SpecialCells(xlCellTypeVisible).Copy _
Destination:=Worksheets("Sheet2").Range("A1")
Application.CutCopyMode = False
Selection.AutoFilter
end sub

Good luck, have fun, and let me know if/how I can be of further
assistance.

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
security constraints when you a excel scripting macro?	douglas	Excel Programming	2	April 4th 09 11:10 PM
VBA scripting	Pete	Excel Discussion (Misc queries)	2	January 9th 09 03:36 AM
Is scripting the way to go here?	LKG[_2_]	Excel Programming	0	September 9th 05 07:22 PM
VB Scripting/Macro - Filling/Editing Worksheet References	Meghan	New Users to Excel	2	December 16th 04 05:55 PM
5.6 Scripting	Jerry[_11_]	Excel Programming	0	July 15th 03 11:55 PM

Menu

About Us