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