Select range starting at active cell

S

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.
 
E

Eduardo

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

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.
 
J

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
 
S

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,
 
Top