Select range starting at active cell

[standard_guy]

I have a simple question but I can't find the answer by looking at the
questions already here.

How do I select a range that is 3 columns wide and 25 rows deep, starting
with the active cell and moving left, then down to define the range?

Thanks in advance.

 

[Luke M]

Range(Selection, ActiveCell.Offset(25, 3)).Select

 

[Eduardo]

Hi,
from the active cell hold the left button in your mouse and highlight the
range you need

 

[Know Enough to be Dangerous]

Standard_guy-

The VBA code Luke M is correct except for one thing. Your post
mentions you want to move left from the active cell. Therefore,
change the 3 in Luke's code to a -3. Also, be warned, you will get an
error message if you process this line of code and the active cell is
in columns A, B, or C.

 

[JLGWhiz]

When using Offset, the count starts 1 cell from fhe current cell. To get
three cells wide and twentyfive deep you need two more columns and
twentyfour more rows.

Sub vert()
If Selection.Column > 3 Then
Range(Selection, Selection.Offset(24, -2)).Select
End If
End Sub

 

[standard_guy]

Thank all y'all. I am sure that has been answered before but I couldn't find
it from the titles. Hopefully my thread title is clear enough that it helps
somebody else. I learn A LOT by looking at threads already here.

Best Regards,