Print only Cells with Data

[The Animal]

Hi.
I have a worksheet A2 to K83 and I want to create a button to print only down to the line that has data from B2 to K83 but the "A" cells is to be included in the print if there is data in the "B" Column.
e.g if there is data in cells B2 to say B20 then I only want to print A2 to K20 and not the remaining blank cells A21 to A83

Thanks Stephen

 

[JoeMo]

Terrific thanks so much

You are welcome - thanks for the reply.