In this publication titled excel vba change paper size, I have provided a complete image from start to finish ,Please look below
