C
CAPTGNVR
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
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