generic use of sheet name in user-defined function

[Eric_in_EVV]

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 ?

 

[Sam Wilson]

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

 

[Patrick Molloy]

I'm sure about the question
so if emplyee is the string variable containg the emplyees name or ID,
you're saying that its also the sheet name for that employee?

function emp_data(employee as string)
with workhseets(employee)
'do something
end with

end function