Bartender Printing Empty Rows - Excel 关注
I set up a template excel document which uses macros to fill and clear itself. The goal was to link my bartender document to this unique excel document, so I could fill my first page, run the macro to fill the page that bartender sees, save, open bartender, print and then clear my worksheet with a macro for the next use (I used the clearcontents function in vba just to ensure that my cells would be empty, because I noticed that bt does not * usually* consider them) .
It seemed simple to use until I tested it.
I tested at first with 6000 rows. It worked fine, it printed 6000 stickers.
When I tried it again, this time with 2000 rows, bt still considered 6000 rows. Even though the last 4000 rows were empty.
How do I fix this?
Why does it do that?
Thanks for the help!