What is the code to selecting entire column for a VBA Macro?

A:A??

"=SUM(Sheet1!A:A)"

Thanks