print out data for selected sheet from combo box without empty rows

[MKLAQ]

Hello,
I would print out data for specific sheet based on selected sheet name from combobox1
CA sheet as example when print out should ignore any empty rows don't contain anything in column A .
thanks

[ByteMarks]

Try

Please Login or Register  to view this content.

Also you need to remove this line

Please Login or Register  to view this content.

[MKLAQ]

thanks,
still print out empty rows contains borders !

[ByteMarks]

Strange. It's works for me. I guess you could just find the last populated row using xl(up).

[MKLAQ]

I use this code to show me used lastrow , and show me row 16 where contains TOTAL word in column A

Please Login or Register  to view this content.

may you check my file,please?
may you tell me what the last row when print out paper, please?
I suppose row 16 , right?

[ByteMarks]

You could try:

Please Login or Register  to view this content.

In this case and for me before, the print preview looks like this.

[MKLAQ]

You could try:

finally it works.

In this case and for me before, the print preview looks like this.

really strange!
thank you so much.

[ByteMarks]

Yes, I'm not sure why Currentregion didn't work for you. Glad the other did!