| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Function to return the active sheet name
Does anyone know of a way to write a customised VBA function that will return
the name of the sheet on which the function is being called? I can do this very easily when that is the active sheet, using the activesheet.name property, but how can this be done when that sheet is not active? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel | |||
| Function from sheet to sheet | Excel Worksheet Functions | |||
| Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
| Return value with using Excel function | New Users to Excel | |||
| Protecting a sheet that includes a solver function | Excel Worksheet Functions | |||
Threaded Mode
