| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
calling a new function Excel gives me #NAME?
I wrote a simple function using VBA Editor. Function prevDay(Ref) Application.Volatile prevDay = Sheets(Application.Caller.Parent.Index - 1).Range(Ref.Address) End Function When I call it Excel gives me #NAME? error. Do I need to register it somehow? sorry for a bloody beginner question and thanks in advance for any help. /mark |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 Slow Function Argument Window | Excel Discussion (Misc queries) | |||
| Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
| Simplify Vlookup function in Excel | Excel Worksheet Functions | |||
| I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
| Missing function in Excel 2003 | Excel Discussion (Misc queries) | |||
Threaded Mode
