Reply to thread

Message

<blockquote data-quote="Magus Coeruleus" data-source="post: 4426629" data-attributes="member: 1704">Thanks for doing this.&nbsp; Don't know if anyone else has interest in the file, regardless of version, but I'm enough of geek to enjoy this for its own sake.&nbsp; So I opened the file in Excel 2007 and it seems to work fine as expected.&nbsp; A question I have is, looking at the macro, how did you specify the area to sort?&nbsp; The relevant code is:&nbsp;Range(&quot;Combatants&quot;).Sort _&nbsp; &nbsp; &nbsp; &nbsp; Key1:=Columns(&quot;A&quot;), _&nbsp; &nbsp; &nbsp; &nbsp; Order1:=xlDescending, _&nbsp; &nbsp; &nbsp; &nbsp; Header:=xlTrueWhere does this name &quot;Combatants&quot; get used to specify the range?&nbsp; There's the second sheet called Combatants but it's sorting (correctly) on the first sheet.&nbsp; Even the column &quot;Combatant&quot; lacks the &quot;s&quot; so I'm curious.&nbsp; My guess, but please tell if you know, is that since you can always right-click on A1 and from there get it to sort (at least in 2007 you can), that saying &quot;Key1:=Columns(&quot;A&quot;) in the macro likewise makes Excel &quot;assume&quot; you want to sort a table consisting of all rows up until where there is a blank one.Regarding InitMod, the reason I made it manual and not autocalculating is because I don't really use the spreadsheet to store all the info on monsters, and sometimes on the fly I just want to throw in the monster's name and initmod without having to specify it's Dex mod.&nbsp; Also, not all monsters have an InitMod = Dex mod + 1/2 level.&nbsp; Certain types (e.g. Soldier, Lurker, Skirmisher) have an additional +2 or +4 by default and I assume some monsters just break the mold regardless.&nbsp; For the Warlord status, right now you have it as PCs always have the warlord bonus and others never do, when sometimes PCs won't have that benefit and sometimes friendly NPCs will.You're right that the second sheet (Combatants) is kind of redundant.&nbsp; At one time I just put the roster of combatants on the same sheet but well below the formatted sorting table.&nbsp; I forget why by at this point I think it's better not to have to replicate tweaks across both sheets.Thanks again for this!&nbsp; Again, if you can confirm or correct my thinking on how that macro works I'd appreciate it.</blockquote>

[QUOTE="Magus Coeruleus, post: 4426629, member: 1704"] Thanks for doing this. Don't know if anyone else has interest in the file, regardless of version, but I'm enough of geek to enjoy this for its own sake. So I opened the file in Excel 2007 and it seems to work fine as expected. A question I have is, looking at the macro, how did you specify the area to sort? The relevant code is: Range("Combatants").Sort _ Key1:=Columns("A"), _ Order1:=xlDescending, _ Header:=xlTrue Where does this name "Combatants" get used to specify the range? There's the second sheet called Combatants but it's sorting (correctly) on the first sheet. Even the column "Combatant" lacks the "s" so I'm curious. My guess, but please tell if you know, is that since you can always right-click on A1 and from there get it to sort (at least in 2007 you can), that saying "Key1:=Columns("A") in the macro likewise makes Excel "assume" you want to sort a table consisting of all rows up until where there is a blank one. Regarding InitMod, the reason I made it manual and not autocalculating is because I don't really use the spreadsheet to store all the info on monsters, and sometimes on the fly I just want to throw in the monster's name and initmod without having to specify it's Dex mod. Also, not all monsters have an InitMod = Dex mod + 1/2 level. Certain types (e.g. Soldier, Lurker, Skirmisher) have an additional +2 or +4 by default and I assume some monsters just break the mold regardless. For the Warlord status, right now you have it as PCs always have the warlord bonus and others never do, when sometimes PCs won't have that benefit and sometimes friendly NPCs will. You're right that the second sheet (Combatants) is kind of redundant. At one time I just put the roster of combatants on the same sheet but well below the formatted sorting table. I forget why by at this point I think it's better not to have to replicate tweaks across both sheets. Thanks again for this! Again, if you can confirm or correct my thinking on how that macro works I'd appreciate it. [/QUOTE]

Verification