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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks