View Single Post
  #6  
Old May 24th, 2011, 11:33 AM
tarquinious tarquinious is offline
Experienced Member
 
First recorded activity by OfficeFrustration: Mar 2011
Posts: 34
Default

Quote:
Originally Posted by jglasermd View Post
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:
  1. You have not yet copied and pasted the code onto a module within your excel spreadsheet
  2. You do not have macros enabled. To enable macros:
    1. Once you have the Developer tab available (see previous post) select Macro Security
    2. Ensure the option "Trust access to the VBA project object model" is ticked
Hopefully this will work for you now.