I have a formula that is used frequently. I created a .xlam and I am trying to save the funtion so I can access it from the user defined menu. Unfortunately, I don't know the programming language well enough. The formula takes the information in the A3 cell and creates a hyperlink. I have created a module, but keep getting syntax errors. I am not sure how to define it. Here is an example (using XYZ for confidentiality purposes) of what I am trying to do:

Function XYZ()

=HYPERLINK(CONCATENATE("PDFS\",MID(A3,1,10),".pdf"),CONCATENATE(MID(A3,1,10),".pdf"))

End Function

Thanks,
Kevin