Select range problem

[Kentae]

Hi
In this example "EndDatabas" ís cell P1120. So I want A11120 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Ä

 

[Jacob Skaria]

Try

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

If this post helps click Yes