print filled data of invoice with ignore the empty cells

[abdelfattah]

hi, every one i have data in sheet1 begins from a2: f38 the empty data begins from a17:a32 i just would code print the filled data and ignore the empty data if a17:a32=""

 

[Toadstool]

If you Hide rows a17:a32 it will print the rows before and after.

 

[abdelfattah]

If you Hide rows a17:a32 it will print the rows before and after.

thanks for your replaying but i need code automatically delete the rows empty becuase sometimes a17,a18 ,etc are filling it depends on how many brands in invoice then delete the rest empty rows