Variable end row for printout macro?

[mrbusto71]

Howdy! I feel like this has a super simple solution that I can't figure out.

Please Login or Register  to view this content.

This code works great to print out a range of names using a static template. My only issue is that I have to manually update the range currently, meaning if there are 16 names, I currently have to specify .Range("B1:B16"). I know there's a way to streamline this so that it automatically knows to end when it finds the first blank in the series, but I'm not sure how to write that out? Any help would be appreciated! Worst case I'll just update it manually

[AB33]

Please Login or Register  to view this content.

[mrbusto71]

Please Login or Register  to view this content.

Awesome, thanks! That works like a charm, and I think I can see what it's doing so I know how to use it in the future also. Win win!