Offsett to select a range of cells

[Matt Houston]

Hi.

I want to offset from say cell A1, to cell A2 in VBA, so I would use something like activecell.offset(1,0).select.

Now what if I didn't just want to select A2, what if I wanted to select A2:A3 from offsetting, does that make sense?

Is there a way?

 

[Matt Houston]

bump

 

[just_jon]

You could -

<font face=Courier New><SPAN style="color:#00007F">Sub</SPAN> foobar()
Range("A1").Resize(2, 2).Select
<SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN></FONT>