In this publication titled how to select entire worksheet in excel vba, I have provided a complete image from start to finish ,Please look below