"Tom Ogilvy" wrote in message
...
You can't use application.Run directly as a function in a worksheet.

If you want to use a function in another workbook (using the function in a
cell), then put the function in an addin and load the addin.

Other than that, it is difficult to see what it is you are trying to do.

Thanks for the post!

It looks as I was not clear in my post. I am trying to figure out how to
call a function in another workbook. I am trying to use a function in a
number of workbooks by having it stored in one place so I don't have to
duplicate a copy in each workbook. Sorry it was unclear.

After your mail, from reading the help it seems I could also add a .xla/.xlt
add in which would contain the function. So I saved my "my vba code.xls" as
a xlt file and added it via the tools add in menu. However, the problem is
the same how can I refer to it from my separate xls workbook?

Thanks for your patience. Is it clearer now?

Cheers, Tom.