VB code for Active cell to the last cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CAPTGNVR - 20 Apr 2008 10:14 GMT

DEAR ALL

I get lastrow = ActiveCell.End(xlDown).Row and

BBB = ActiveCell.Address(ROWABSOLUTE:=False, COLUMNABSOLUTE:=False)

Range(BBB :K" & lastrow) does not work.

What should be the code to select a range from active cell to the last row
and till colum K?

Can any one help me, pls.

BRGDS/CAPTGNVR

Reply to this Message

Rick Rothstein (MVP - VB) - 20 Apr 2008 10:23 GMT

BBB contains a String value so you have to concatenate it with other text.
Use this...

Range(BBB & ":K" & lastrow)

Rick

> DEAR ALL
>
[quoted text clipped - 11 lines]
>
> BRGDS/CAPTGNVR

Reply to this Message

CAPTGNVR - 20 Apr 2008 10:32 GMT

D/RICK

BINGO. Pretty quick response. Tried and working like a charm. Thank u.

brgds/captgnvr

> BBB contains a String value so you have to concatenate it with other text.
> Use this...
[quoted text clipped - 18 lines]
> >
> > BRGDS/CAPTGNVR

Reply to this Message