Hi Jessie, If you attach a sample workbook, we will be able to help you better. I use this method a lot, but I need to know how your data is laid out. Regards - Dave.
> Date: Sat, 4 Jul 2009 04:57:42 -0700 > Subject: $$Excel-Macros$$ FIND COMMAND IN EXCEL VBA > From: jayachitra.dreamzunlimi...@gmail.com > To: excel-macros@googlegroups.com > > > Hi Guys, > > Am new to the forum and learning basics of Excel Vba. I now need to > find a list of values from sheet2 and delete it from sheet1. Tried > using the Find command in the following way > > Cells.Find(What:=Sheet2.Cells(R2, C2), After:=ActiveCell, LookIn:= _ > xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, > SearchDirection:= _ > xlNext, MatchCase:=False, SearchFormat:=False).Activate > > ActiveCell.EntireRow.Delete > > But this deletes the row from the sheet2. I need to delete the row > from sheet1. > All that now i want to know is how do i differentiate between i.e > through return value of the find function. > 1. The search string is found > 2. Search string is not found > > Plz help me out. This problem is really bugging me... > > > _________________________________________________________________ POP access for Hotmail is here! Click here to find out more http://windowslive.ninemsn.com.au/article.aspx?id=802246 --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
