| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
generic use of sheet name in user-defined function
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 ? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Application Defined or object defined error..?Need help generic er | Excel Programming | |||
| Using dcount function within user-defined worksheet function | Excel Programming | |||
| Excel - User Defined Function Error: This function takes no argume | Excel Programming | |||
| Need to open the Function Arguments window from VBA for a user defined function. | Excel Programming | |||
| User-Defined Function pre-empting Built-in Function? How to undo???? | Excel Programming | |||
![Eric_in_EVV[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
