Not ignoring worksheets

[wwu-dillon]

Please Login or Register  to view this content.

I have a problem with my code written above. this section:

Please Login or Register  to view this content.

is not working and the array i have named is being deleted on this worksheet as well. i want to be able to input the worksheets ex. pivotdata, sumtable and have them be pardoned from the deleting. any thoughts?




thanks

-dillon

[wwu-dillon]

Please Login or Register  to view this content.

i tried changing this line to

Please Login or Register  to view this content.

didnt work. also tried

Please Login or Register  to view this content.

didnt work. any suggestions to look into or anything. also i think that maybe the problem has to do with the case else as it is unbound, or would the sheets be ignored since they fit into the case section. lemme know your thought or suggestions on fixing this problem.


ty in advance.

[royUK]

You are telling it to check for Upper Case, but using Lower Case. You don't need to loop through an array eitherr

Please Login or Register  to view this content.

[wwu-dillon]

thank you very much for your help. i just changed them to uppercase because i dont understand the looping thing and its still working. thank you very much royuk