Continue code on next line: Compile Error: expected list separator or )

I am currently using a macro to search my spreadsheet for terms and if it finds them to delete the entire row.

This has worked fine up until i hit the 1024 character line limit.

I have tried using &_ as well as _ to bring continue the code on the next line and get "Compile Error: expected list separator or )"

Showing only 3 terms but it continues past 1024 characters....

Please Login or Register  to view this content.

As Always Thanks In Advance!

Also here if full code.

Please Login or Register  to view this content.

Hello there,

Is this code only being used by you? The reason I ask is because it might be easier to provide the user with an input box which asks the user to type the value they want to search for and delete. You could use a yes no messagebox with this that would ask if the user wants to search another value where if yes is selected to provided the inputbox again if no is selected exit the code.

Thanks!

so create a sheet that i can inject into my report that has each of my terms listed in column A. next have code that searched that sheet and compares it to column A on my current sheet and delete rows that match. After that is run i can then remove the sheet from the report.

I can figure it all out except the code to Search column A on Sheet2 and if it finds a match in Column A on Sheet1 then delete entire row.

i dont think a messagebox will work because there are a lot of search terms like 30 now

Hello there,

Try the following. First select the worksheet in which the values you are searching for are in column A

Please Login or Register  to view this content.

Worked perfect! I have added to both your reps!

Thank you for the star tap!