Code error in Array

**BDD2015** · 01-19-2017, 10:22 AM

I am running a macro that clears an array of specific text. I don't know enough to figure out why I can't run it successfully. The array includes approx. 120 names. I am wondering if it is too long? The text in red is where it hangs up.

Please Login or Register  to view this content.

**davesexcel** · 01-19-2017, 10:51 AM

[/close] is the correct way to close the wrap

**davesexcel** · 01-19-2017, 10:56 AM

What is the error you are getting?

Please Login or Register  to view this content.

errors for me,

**BDD2015** · 01-19-2017, 10:56 AM

Wrap" as in the code I provided davesexcel? If so - but, but, lol - but last week I was told "Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code between

Please Login or Register  to view this content.

..."

**BDD2015** · 01-19-2017, 10:57 AM

It stops and highlights the -
If StrComp(Range("e" & i), dontClear(j), vbTextCompare) = 0 Then

**davesexcel** · 01-19-2017, 10:57 AM

Originally Posted by BDD2015

Wrap" as in the code I provided davesexcel? If so - but, but, lol - but last week I was told "Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code between

Please Login or Register  to view this content.

..."

Ya, I'm just saying it should be "/" not "\"

**davesexcel** · 01-19-2017, 10:59 AM

Originally Posted by BDD2015

It stops and highlights the -
If StrComp(Range("e" & i), dontClear(j), vbTextCompare) = 0 Then

Yes, but what is the error you are getting?

**BDD2015** · 01-19-2017, 11:26 AM

Sorry. Guess I am not using the correct words. I don't get an error per se. It just stops at now one of two lines, and highlights it in yellow.
At either -

Please Login or Register  to view this content.

**davesexcel** · 01-19-2017, 11:43 AM

Usually a msgbox pops up, telling you what the error is.
There are things in your code that can't be recognized,
what is:?
LBound(Delete) To UBound(Delete)
dontClear(j)

You can also edit your original post and change [\code] to [/code] , that way your code will be wrapped

**BDD2015** · 01-19-2017, 11:46 AM

No, no message. Here is the workbook if you'd like to have a look.

**davesexcel** · 01-19-2017, 11:52 AM

There's no way this code will work as it is, you are referencing functions that do not exist

**BDD2015** · 01-19-2017, 12:05 PM

Can you explain or help fix the code? It does work when I use two names but again this list is massive. And I really, really do not understand VBA much at all. I've just been here for a week trying to get this job done, finding and modifying macros from online. Again, weird because it does work with two names.