Issue Printing to Zebra Printer Via PrintOut

Hello,

I am attempting to generate a macro to print a simple label via a Zebra LP 2844 label printer. The number of labels to be printed is variable, handled by a textbox. If I manually select my print area and manually print the selection a label is printed as I would expect. When I run the following code, a blank label is printed.

I've spent hours searching this forum and other resources in an attempt to troubleshoot this but I'm coming up short. Any ideas on what I'm doing wrong where a blank label is printed when running the following code?

Please Login or Register  to view this content.

Thanks!

Figured it out, but in case anyone else runs into a similar issue...…

The problem seems to be caused by cells being merged. My named range (Print_Area) is equal to Range A1:Z26. However, this range was merged. With these cells merged, it was only printing the contents of cell A1. I unmerged these cells, reformatted the data and then named the range again. This resolved the issue.