Quote:
Originally Posted by jglasermd
you can ignore #1, I got it to work with your suggestion. Still trying to get your function to work; I keep getting a !NAME error.
|
Excellent about the graph, though I suggest you try my later suggestion as it may be slightly better.
You will be getting the #NAME? error for one of 2 reasons:
- You have not yet copied and pasted the code onto a module within your excel spreadsheet
- You do not have macros enabled. To enable macros:
- Once you have the Developer tab available (see previous post) select Macro Security
- Ensure the option "Trust access to the VBA project object model" is ticked
Hopefully this will work for you now.