Excel Report Generation - reduce Rows

[ben64]

---

Bob_Schor a écrit :

Cool!  I tend to stay away from ActiveX (although I have "descended into its murky depths" for doing some basic things that the RGT doesn't quite support), but hadn't learned of this trick.  I put a suggestion on the Idea Exchange to include a "Get Last Column" function -- maybe you should comment there (or put in your own Idea Exchange suggestion), particularly if your method can handle both Rows and Columns, and won't be "fooled" by whatever caused the OP's Excel file to report 2000 rows when there were only 39.

Bob Schor

---

I'll look into it this week.

Ben64