Select from fixed cell to used range

[Manish Sharma]

Hi Friends,

I am very simple query, but i am not able to find out how to do it.

In the attached file, i want to select the range from cell B8 (which is fixed), to used range i.e. till Cell F18 (but the problem is, cell F18 is not fixed). Last used row or column can change.

Thanks & Regards,
Manish

 

[Luke M]

We can use the SpecialCells object to get what you want.

Sub select_range()
With ActiveSheet
    .Range("B8", .Cells.SpecialCells(xlCellTypeLastCell)).Select
End With

End Sub

 

[Manish Sharma]

We can use the SpecialCells object to get what you want.

Sub select_range()
With ActiveSheet
    .Range("B8", .Cells.SpecialCells(xlCellTypeLastCell)).Select
End With

End Sub

Thanks a lot Luke M for the quick response with solution.
My problem is solved

I was not aware of SpecialCells object, if you dont mind then can you please tell me something about these special cells or if you can give me some weblink from where i can refer more info about it.

Thanks Luke.

 

[Luke M]

You're very welcome, Manish.

Take a look at this article for more info about SpecialCells.
http://www.ozgrid.com/VBA/special-cells.htm

 

[Manish Sharma]

You're very welcome, Manish.

Take a look at this article for more info about SpecialCells.
http://www.ozgrid.com/VBA/special-cells.htm

Thanks Luke, for all your quick help.

Take care,
Mani