Marco to copy from active cell to top of column

Am trying to write a macro that will select the range from my active cell<which will be the last cell in a column> to the first cell in the column

with activesheet
.range(activecell,.cells(1,activecell.column)).select
end with

is one way.

Balthasar G wrote:
>
> Am trying to write a macro that will select the range from my active
> cell<which will be the last cell in a column> to the first cell in the
> column
>
> --
> Balthasar G
> ------------------------------------------------------------------------
> Balthasar G's Profile: http://www.excelforum.com/member.php...o&userid=37264
> View this thread: http://www.excelforum.com/showthread...hreadid=569798

--

Dave Peterson