Selecting a range in VBA when you only have row/col NUMBERS

[ratbags21]

We are all familiar with the statement:

Range(A1:B4).select

But what if you do not have "A1" or "B4" but numbers eg

Top left co-ordinate=1,1 and the bottom right co-ordinate=
2,4 (you get these from activecell.row or activecell.column syntax when you are navigating around the range#

How do I select a range with row & column numbers only?

Many thanks

 

[Norie]

You could try this.

Range(Cells(1,1), Cells(2,4)).Select

Note there could be various issues with this code depending on your other code, and also you don't generally need to select a range to work with it.

 

[onlyadrafter]

Hello,

something in the lines of

a = 10
b = 10
c = 12
d = 12
Cells(a, b).Select
Range(Selection, Cells(c, d)).Select

 

[ratbags21]

Range selection problem

You could try this.

Range(Cells(1,1), Cells(2,4)).Select

Note there could be various issues with this code depending on your other code, and also you don't generally need to select a range to work with it.

Thank you very much - this is exactly what I want!