Join two VBA codes together

Hi all,

Have been working with VBA a bit now, still a noob but learning everyday thanks to these forums.

I simply have 2 codes that i want to assign to the same button, the first code is a kind of vlookup type copy and paste, and the second a output to pdf.

I have tried joining together but keep getting errors. Any help be great. Please see codes below as two separate subs

Please Login or Register  to view this content.

What I need is to join these two subs together into one, I thought a "Then" function would have done this but to no avial

Thanks in Advance

Either:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

Assuming you are calling one module from the other, sht1 might not be defined in your PDF sub, so it would need to be:

Please Login or Register  to view this content.

However, I think that would give you a different error to the one you mention, I would check that the filename is valid, and that the directory exists and you are able to write to it.

Thanks all for your replies,

The problem was indeed an invalid file name, I have sorted it now.

Thanks again to all, Rep added