I am trying to create a macro that will print out a row of information. This
macro will be embedded into an autoshape at the end of each row.

The Column Titles are in Row 2 from A2:O2
The information that I would like to print out is in A3:O3

The print would have the column title followed by the information from the
cell below it. (i.e.: A2 with A3's info to the right of the title, B2 with
B3's info to the right of it, etc. etc. up to O2 and O3) The macro would grab
the column titles and the information from the assigned row and print out to
the default printer.

in Cell P3 I have placed the clickable autoshape for the macro to be
embedded into.
I want to use this macro in every row there after still keeping Row A2:O2 as
the titles. Is this possible?