tdp23 0 Posted August 3, 2011 Hi Either there's a bug in v2.1 or I'm doing something wrong, but I'm getting an error message when I try to input keeper info ("Run-time error 1004. Calculate method of Range class failed."). My league has keepers that cost a draft pick. I've set that up in the Rules tab (max keepers 4, keepers cost a draft pick "yes"). I've also enabled macros, and I've double checked all of this by closing the file and coming back into it. On the Keepers tab I'm getting that error message when I enter the specific draft pick. For example, I set the position as "RB", I set the name as "Jamaal Charles", and so far so good, but then I set the draft pick as "1.03" and if I try to click away from the cell I get the error message. It doesn't matter how long I wait before clicking away from the cell. The error message gives me two options: "End" or "Help". "Help" takes me to a generic explanation that I have pasted at the end of this post, but it sounds like it requires more detailed tinkering to fix. "End" bounces me to the Draft Report tab where no picks/keepers shpw up. No players are removed from the Overall tab either. But if I click back to the Keepers tab it shows Charles being protected for the 1.03 pick just as i entered it (so it's getting into the Keepers tab but the Keppers tab is not getting the info out to the other tabs). I did see that someone else was having an issue with keepers in another post, but my interpretation of that exchange was that it related to the use of the reset keeper/draft order feature, and once he understood how that worked everything was fine. My reset option is set to NO for both keepera and draft order, so I don't think this is the issue for me. The error help message is as follows: Macro Error There is an error in the macro you were running. The specified method can't be used on the specified object for one of the following reasons: An argument contains a value that is not valid. A common cause of this problem is trying to gain access to an object that does not exist; for example, Workbooks(5)when only three workbooks are open. The method can't be used in the applied context. Specifically, some Range object methods require that the range contain data. If the range does not contain data, the method fails. An external error occurred, such as a failure to read or write from a file. A method or property can't be used because of security settings. For example, the properties and methods of the VBE object for manipulating the Microsoft Visual Basic for Applications (VBA) code stored in an Microsoft Office document are inaccessible by default. To turn on trusted access to Visual Basic Projects: On the Tools menu, point to Macro, and then click Security. On the Trusted Sources tab, select the Trust access to Visual Basic Project check box. For more information about how to use the method, search for the method name in Visual Basic Help. Share this post Link to post Share on other sites
Mike MacGregor 20 Posted August 3, 2011 Hi tdp23. When you select the draft pick using the drop-down, it really should just be a case of the CC/DB copying the player and pasting him next to the appropriate pick on the draft report tab. Perhaps it is having trouble figuring out where that player should go. Can you send me your copy of the CC/DB, so I can look at it specifically? I'm at compiler@fftoday.com Share this post Link to post Share on other sites