This should give you the idea:

Public function demo_udf(byval ws as string)

demo_udf = worksheets(ws).range("A1").value

end function

If you type "Sheet1" in cell A1 on Sheet2, the put =demo_udf(A1) in B1 on
the same sheet it will return the value of A1 on Sheet1.

Sam


"Eric_in_EVV" wrote:

I have a workbook that has a separate sheet for each employee. I need to
write a function that sums certain cells based on meeting certain criteria
for each employee. The layout of each employees sheet is identical. How can
I write the function so it will generically use the sheet name in the forumla
as opposed to having to spell it out ?