Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
My macro first sorts Column A which contains a string of text alphabetically. It then compares the text down each consecutive row and prints, "Repeated Entry" in Column B next to it if they are found. It then sorts Column A:B alphabetically along Column B. At this point and to do a repetition, For N = 1 to 100 is used. It then searches for the words "Repeated Entry" and deletes that row. Then comes, Next N. Here is where I need some help. If there are less than 100 "Repeated Entry" lines, I get the message, "Run time error '91': Object variable or With block variable not set". The macro execution then stops. How can I error trap this so as to allow the execution to continue on? TIA Tom |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VB Codes | Excel Discussion (Misc queries) | |||
ZIP CODES | Excel Worksheet Functions | |||
Am I asking to much from vb codes? | Excel Worksheet Functions | |||
VBA Codes | Excel Worksheet Functions | |||
Zip Codes | Excel Discussion (Misc queries) |