View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
CAPTGNVR[_2_] CAPTGNVR[_2_] is offline
external usenet poster
 
Posts: 87
Default VB code for Active cell to the last cell

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