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

"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 ?