I am writing a macro in Excel. I go to one sheet, find the next item in a
list, switch to a different sheet, and find the item in a different list.
I end up with errors when an item that is on the first list is not on the
second list. I am using On Error goto to try to circumvent this problem,
but it isn't working. I think I need to have a statement that says something
like: If cells.find (parameters) = false then goto X subroutine (which goes
back to the first sheet to find a new item), but this syntax doesn't seem
to work. Any ideas how I can deal with a search using cells.find that doesn't
find anything? Thanks for your help. Please email to rfbuzan0@mailbox.sc.edu