Posted to microsoft.public.excel.programming

K[_2_]

external usenet poster

Posts: 557

Delete Entire row if value don’t match

Hi all, I got list in Range("A2:A10") of sheet 1 like see below

A………col
LC1
X2Y
GFS
TLL
FST
NWM
ZRS
TWW
UIS

I want macro to check in column A of sheet 2 the values of Range
("A2:A10") of sheet 1 and if any value in column A of sheet 2 don’t
match with the values of sheet 1 then macro should delete entire row
in sheet 2
Please can any friend can help

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
Delete Entire Row	K[_2_]	Excel Programming	4	March 3rd 09 03:40 PM
VLookup Not Searching the entire cell for Match	LAP	Excel Discussion (Misc queries)	3	February 23rd 07 05:40 PM
Delete Entire Row if value is not Q	Sean	Excel Programming	16	February 7th 07 02:06 PM
Delete Entire Row	Corey	Excel Programming	4	February 6th 07 12:24 AM
Need to delete last value in column but not delete entire row	[email protected]	Excel Programming	4	October 19th 06 05:26 PM

All times are GMT +1. The time now is 03:37 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us