Posted to microsoft.public.excel.programming

external usenet poster

Posts: 39

Copy row on criteria

I want to copy then entire row from WS "raw_copy" to "RC_new" if the
text in column E contains a substring of "Alarms"
I was hoping this code would do it ... compiler error
Do I have a syntax problem or a logic problem THXs

Worksheets("Raw_copy").Range("E1:E" & g_var1).AdvancedFilter
Action:=xlFilterCopy, CopyToRange:=Worksheets("RC_New").Range( _
"A1"), Unique:=False, CriteriaRange:=Range("Alarms")

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
Copy is criteria met	Kitten74	Excel Worksheet Functions	3	April 29th 10 05:35 PM
Copy is criteria met	Don Guillett[_2_]	Excel Worksheet Functions	2	April 29th 10 05:09 PM
Copy is criteria met	Don Guillett[_2_]	Excel Worksheet Functions	0	April 29th 10 04:20 PM
Copy with criteria	acw[_2_]	Excel Programming	0	February 6th 04 12:06 AM
Copy with criteria	James Stephens	Excel Programming	5	November 11th 03 10:51 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us