Marco to copy from active cell to top of column
 

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

--
Balthasar
-----------------------------------------------------------------------
Balthasar G's Profile: http://www.excelforum.com/member.php...fo&userid=3726
View this thread: http://www.excelforum.com/showthread.php?threadid=56979

Marco to copy from active cell to top of column
 

with activesheet
.range(activecell,.cells(1,activecell.column)).sel ect
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