Results 1 to 10 of 10

Thread: Summary Of Maximum Rows Used Across Each Sheet In A Workbook

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #10
    Forum Guru Rick Rothstein's Avatar
    Join Date
    Feb 2012
    Posts
    662
    Rep Power
    14
    Quote Originally Posted by Admin View Post
    @ Rick - like Addr, you also need to reset MaxRow variable as well.
    I had finished writing the code and then posted it literally just before going to sleep for the "night" and I completely missed the row numbers weren't changing in the outputted MessageBox. Thanks for spotting the problem! I added the appropriate line of code in Message #8 so the code there now reads correctly.
    Last edited by Rick Rothstein; 09-04-2015 at 08:10 PM.

Similar Threads

  1. Replies: 1
    Last Post: 05-24-2015, 03:02 PM
  2. VBA to Get Sales SUMMARY of Multipple Sheet
    By mag in forum Excel Help
    Replies: 0
    Last Post: 12-27-2012, 07:39 PM
  3. VBA to Get SUMMARY of Multipple Sheet
    By mag in forum Excel Help
    Replies: 10
    Last Post: 12-27-2012, 04:09 PM
  4. Chart Summary help
    By sanjeevi888 in forum Excel Help
    Replies: 1
    Last Post: 07-08-2012, 06:06 PM
  5. Replies: 9
    Last Post: 09-09-2011, 02:30 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •