Help with Importing Part of a text readable file into Excel worksheet via Macro

You had me pulling my hair out,

Duh..................

Right.

You created an activex command button and assigned my macro to it.

So......................................

activex macros are sheet specific. You know that because you right click on the sheet name and select view code to edit them

Sheet Specific macros can only operate in the worksheet that they sit in.

So hence all the debug messages

If you want to use your existing command button, then you have to move most of the code to a normal macro module and call it as a subroutine