Try

Range("A1","EndDatabas").Select

If this post helps click Yes
---------------
Jacob Skaria


"Kentae" wrote:

Hi
In this example "EndDatabas" Ã*s cell P1120. So I want A1:P1120 to be
selected, but I get A1: Q1120!!

Range("EndDatabas").Select
myRowNr = ActiveCell.Row
myColNr = ActiveCell.Column
Range(Cells(1, 1), Cells(myRowNr, myColNr)).Select
Wat's wrong?
Thanks in advance
//KentÄ