Select range problem

K

Kentae

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Ä
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to Select text from a point given to a specific word 2
Definition dynamic minverse 0
VBA for Dependents shortcut menu 0
If .Column > 7 And .Row > 25 then go to B8 22
VBA: Attach a variable to a range after executing Find command 1
Transpose data into a single cloumn 6
Help me4 2
Pasting a cell into bookmarked table from excel vba 1

Top