merge several VBA

[Soph']

Morning
I want to merge several macros (NameRange, Vlookup, Subtract) into one called General. When I run the macros individually in the order described above, they all work. When I merge them, they just bug along the way. I've attached the file with all of them in it.
NameRange runs but doesn't perform anything and Vlookup comes with a compile error: "Type-declaration character does not match declared data type".
I haven't been able therefore to test further with Subtract. Could someone help and explain why a simple copy-paste is not working?
Thanks a bunch (as always).

 

[KenU]

@Soph' ,

I added a Dim statement at the top and moved some other declarations up to use in the first part of the general routine. What is there now runs, but I have not done any checking.

I hope that helps.

Regards,
Ken

 

[Soph']

Thanks, changed it a bit more and it works wonders.