Range selection VBA

[Mr2017]

Hi

I'm trying to select a range in VBA (from cell A2 to M2 down to the bottom of the range of data), but the Sub is going to the bottom of column A instead of selecting the range.

Can someone please clarify why?

I used this code:

Sub R1()


Range("A2:m2").End(xlDown).Select


End Sub

 

[Joe4]

It sounds like you do not have any data in column A beyond row 2.
Is there some column that will ALWAYS have a data entry for all rows that contain data?

 

[Joe4]

Note that if you are just trying to select the whole range, and there are no "gaps" in your data, you could just use Current Region, i.e.

Range("A2:M2").CurrentRegion.Select

 

[Mr2017]

Hi Joe

Thanks for the prompt response.

There actually is data in every row in column A.

If you look at this sample of data, which has data in cells A1:C4, the same thing happens ie the Sub goes to the end of the data in column A, instead of selecting the range A2:C4 (the Sub has been modified to go up to column C to answer your question, with a simple example)

Sub test()


Range("A2:c2").End(xlDown).Select


End Sub

1	2	3
a	d	g
b	e	h
c	f	i

<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[Joe4]

Because that code is just selecting a single cell, not an entire range.
Try:

Range("A2:C" & Range("A2").End(xlDown).Row).Select

 

[Mr2017]

Thanks Joe.

Apologies for the delay in responding. Some other things came up.