how can i eliminate blank rows that exist beyond the last non-bank row?

Originally Posted by Joe Miller

please let me know if it was me that cross posted? i don't think it was?

Unless by coincidence somebody else with the same name as you asked the exact same question as you on another forum a few hours before you asked it here, then yes, it was definitely you.