Excel VBA - Easy Question

[Gian624]

This should be a really easy question for you VBA experts. I have the following code:

Range(Selection, Selection.End(xlUp)).Select

What I would like to do is have one line code that does the above but then keep the selection but one cell below the full range. For example, if the code above selects the range A11-A1, I want it to select A11-A2 instead.

Thanks so much for your time and expertise in advance,

Mat

 

[Fluff]

Try

Range(Selection, Selection.End(xlUp).Offset(1)).Select

But there is very rarely a need to select anything, it just slows done the code.