View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jen[_15_] Jen[_15_] is offline
external usenet poster
 
Posts: 2
Default Using a Table in my VBA User Defined Function

Hi,
I am making a UDF that is an engineering equation. This equation
requires looking up data in a set table. I want to be able to use
this in several of my spreadsheets, without having to copy the table
into each one. Is there a way to incorporate it into my UDF so that
it can reference the table or do I have to add a sheet to my
personal.xlsb and then do it that way? I want to make this UDF into
an add-in so that it is easier to share with collegues. Thanks!
Jen