Copy variable length column to clipboard within a macro

I have a workbook where, within a macro, I want to copy a column of contiguous non-blank entries to the clipboard. I need to do this within a macro. However, the number of entries I want to copy is variable. I can calculate how many rows I need to copy and store this on the worksheet if necessary. I have tried selecting the top row and the pressing the ctrl-downarrow shortcut key during the recording of the macro, but this only records the static position that the cursor jumps to at the time the macro is recorded. (And besides it doesn’t select all the cells in between.) Can anyone offer an approach? Can you do it with a recorded macro or is writing VBA code necessary? Sounds simple, but I’m not a VBA programmer....

OK.. thanks for the reply....it worked (mostly), but there is a new twist...the list above is created with a formula that sometimes results in a """ and sometimes actual values. So, when I use the ctrl-shift-downarrow, it treats the "" value as a non-blank and continues on down the column (not as I intend). I have control of what null value goes into the cells to represent "blank". Is there some blank value that will stop the ctrl-shift downarrow?