Print selected cell in 1 sheet

Hi guys,

Need help here.

I try to print certain data with selected cell. It works to preview the print. However, it showed cell by cell and the user need to click next page to view another cell. Here is the code I try to do.

Please Login or Register  to view this content.

Print preview image showed here:

print 1.jpg

print 2.jpg

Thanks!

Originally Posted by patel45

If you want print selected cells what is the meaning of this line ?
Range("A8:A60,B8:B60,C8:C60,D8:D60,E8:E60,F8:F60,G8:G60,H8:H60,I8:I60,K8:K60").Select

It's mean I want to print for the cell A, B, C, D, E, F, G, H, I and K (from row 8 to 60). I got data in cell J but don't want to print that area.

Btw, thanks for your reply.

Apologize for the title make you misunderstanding. Its correct for your previous understanding. I want select certain cell and run macro to print selected cell.

But, it appear one cell on the page in the print preview. I'm still don't know what are the problem with that code.

Apologize for late reply. Attached sample work book I created.