| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Macro user function used in several sheets in same workbook
Modify your definition of UltimaFetcha:
UltimaFetcha (new Date,"some text", ThisWorkbook.Sheets("sheetname") Function UltimaFecha(Fecha As Date, celda As String, sheet as WorkSheet) As Date Application.Volatile * Fecha = sheet.Cells(sheet.Cells.Rows.Count, celda).End(xlUp).Value * UltimaFecha = Fecha End Function |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| want to share workbook but limit the sheets each user sees | Excel Worksheet Functions | |||
| Shared Workbook with user code lookup to display sheets | Excel Programming | |||
| Using a user-defined function from the Personal workbook | Excel Programming | |||
| Macro for filter on protected workbook that works for all sheets, no matter what sheets are named? | Excel Programming | |||
| Macro, Module, function, sub and This workbook and sheets ? | Excel Programming | |||
![gimme_this_gimme_that@yahoo.com[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
