EXCEL VBA works in 1 workbook, but not another.

[Tomkat53]

I have this code which allows me to paste text from the clipboard into merged cells.
It is very handy, which is why I would like to use it in ANOTHER workbook.
However, even though it works perfectly in the workbook I created it in, when I copy/paste it into another workbook, it errors with
"User-defined type not defined."

Does anyone know why?

 

[Joe4]

You probably don't have the correct libraries/references selected on the other computer.

From the computer where it does work, go into the VB Editor, and from the Tools menu, select References.
Note which libraries/references have been selected.

Now repeat the process on the computer that does not work.
You will most likely find you are missing some. Find and select the missing ones, so this computer has all the same ones selected as the other one.

 

[Tomkat53]

You probably don't have the correct libraries/references selected on the other computer.

From the computer where it does work, go into the VB Editor, and from the Tools menu, select References.
Note which libraries/references have been selected.

Now repeat the process on the computer that does not work.
You will most likely find you are missing some. Find and select the missing ones, so this computer has all the same ones selected as the other one.

They are on the same computer. I run the 2 workbooks simultaneously.

 

[Joe4]

Still, follow the same procedure in each workbook as I laid out, and see if the references are exactly alike.
If they are not, correct them, and it should work.

 

[Tomkat53]

Still, follow the same procedure in each workbook as I laid out, and see if the references are exactly alike.
If they are not, correct them, and it should work.

THAT WAS IT, THANK YOU!

 

[Joe4]

You are welcome.