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.
--
Rick H

Range(Selection, ActiveCell.Offset(25, 3)).Select
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"standard_guy" wrote:

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.
--
Rick H

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

"standard_guy" wrote:

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.
--
Rick H

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.

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

"Know Enough to be Dangerous" wrote:

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.

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,
--
Rick H


"JLGWhiz" wrote:

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

"Know Enough to be Dangerous" wrote:

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.