View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jairo Marin Jairo Marin is offline
external usenet poster
 
Posts: 1
Default Personal.xls Macro Function for Everyone...

Hey Group!!!


How can I expose a function that I can use after in wherever I want. I tried
the following way, but I couldn't

In Personal.xls in a new Module:

Public Function MyFunction() as string
....Lines
End Function

when I open new.xls
and I write:
CellA1= MyFunction(Some Args)

I am tryieng to use it like Sum(), for example...

It returns to me: N/A

So... it is Impposible????