Reference Error Macro VBA

Hi, I messed up! hehe

Im not an VBA expert which you will see.

I was looking for a code to rewrite a macro from another macro. I found a bit of code that i thought could do it for me but now im afraid it messed up references in other macros in the same workbook! After I did run the macro which actually changed | to ; in my module Departments this and some other macros reads from the wrong sheet. Nothing has changed in them though from what i can see.

This is the code:

Please Login or Register  to view this content.

--------------------------------------------------------------------------------

Here is the code that does no longer gets data from "DEPT". Probably could do this alot better but atleast it worked at first.
Now it gets data from another sheet. No longer from "DEPT"

Please Login or Register  to view this content.

Which part of the code is referencing the wrong sheet?

By the way, why are you using code to change one character in a sub?

If you wanted the sub to work with different delimiters, eg ; or |, it could be rewritten to take the delimiter as an argument.

How does this work?

Please Login or Register  to view this content.

You call it like this, passing the required string for the delimiter.

Please Login or Register  to view this content.