How to Select Current column

Hi. I'm new.

Need a macro that selects the *current* column's text from second cell all the way down & copy it to clipboard (besides the heading).

If I put my cursor in cell B2, for example, & press CNTRL+End+ArrowDown & then Cntrl+C will do this..but, I need it to be universal, so that when my cursor is in a random cell in Column D, for example, it will select + copy everything in Column D2 to the end of column D...

The problem is that the column I select & copy changes constantly so I can't just do record as that sticks it column G or F or whatever...

Excel 2007
Thanks!

Perhaps like so?

Please Login or Register  to view this content.

Thanks for trying...that didn't work...

Sorry, I don't really understand macros, that's why I'm asking for help...maybe I need to add something to the above...not sure..