| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
compare two worksheets and delete rows
Not to usurp any credit from Tom, nor to "show him up", but this ma work. Replace If sh1.Cells(i, "A").Value = sh2.Cells(i, "A").Value Then with If sh1.Cells(i, "A").Value = Cells.Find(sh1.Cells(i, "A").Value ActiveCell, xlFormulas, xlWhole, xlByColumns, xlPrevious, False, False Then This should search the entire sheet2 to find the value on sheet -- bgeie ----------------------------------------------------------------------- bgeier's Profile: http://www.excelforum.com/member.php...fo&userid=1282 View this thread: http://www.excelforum.com/showthread.php?threadid=54599 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare Rows and delete duplicate records | Excel Worksheet Functions | |||
| Help! -How to compare two worksheets; multiple rows of data=result | Excel Worksheet Functions | |||
| Compare 1st 8 digits of rows in three worksheets | Excel Worksheet Functions | |||
| Add or Delete Rows in Protected worksheets | Excel Discussion (Misc queries) | |||
| Using VBA to delete certain worksheets rows | Excel Programming | |||
![bgeier[_18_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
