VBA to print data from cells in excel onto A4

I have list of text in two columns. I want first column text to be first line in A4 and second column to be second line. I have standard page setup like border, font size, alignment , color , style etc. So each row will be printed onto a A4 sheet. This can be either printed to PDF format or to a printed. This has to be automated. Once i click a button all the rows which i have data it has print all.