Trying to assertain why this macro will not work.
If Not IsError(.Value) works fine with one item
but If Not IsError(Application.Match(.Value, _ - will not delete the row items from the list in col A
What am I missing - End If is active with If Not IsError(.Value) but compile error end if w/o block if
Please Login or Register to view this content.
Check your indents. You are missing an End If before the End With/Next Lrow/End With
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
I get no compile error with your code.
You have 3 lines commented out. Are you sure the last of those lines was a comment when you got the compile error?
If I uncomment the End If I get the error message
Can you show me where it's needed so I don't get the error msg?
Last edited by 3345james; 05-18-2018 at 10:52 AM. Reason: attach a file for testing
You don't need it. Leave it as a comment.
I attached a file
How aboutPlease Login or Register to view this content.
Fantastic - Thanks!
Thank you also for placing into an array - helps me know how for future use.
Appreciated
jim
Glad to help & thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks