How to select range from ActiveCell to cell 1058476 in the same column.

[Ingemar]

Hello,

I am trying by VBA code to sekect a range from the active cell to the very last cell in the same column (on row 1048576) regardless if it is empty or not. I have tried the code below without sucess.

Range(ActiveCell, ActiveColumn & 1048576).Select

Greatful for any suggestion.

Ingemar

 

[Fluff]

How about

ActiveCell.Resize(Rows.Count - ActiveCell.Row + 1).Select

 

[MARK858]

Range(ActiveCell, Cells(1048576, ActiveCell.Column)).Select

or

Range(ActiveCell, Cells(Rows.Count, ActiveCell.Column)).Select

 

[Ingemar]

Hello Fluff and Mark858!

I see no difference in the functionality of your three suggestions. All codes work great.

THANK YOU for the help.

Kind regards

Ingemar

 

[MARK858]

From experience Resize uses more resources than referring directly to the range and so has an effect if you are dealing with a lot of large ranges. It won't make any difference what code you use with what you are doing.

The use of 1048576 in the first code I posted means that it won't be backwards compatible with anyone using below Excel 2007 so it will error if you ran it on a computer running 2003 for example.
Both the other codes using Rows.Count are backwards compatible.