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!