Select range starting at active cell
 

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

Select range starting at active cell
 

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

Select range starting at active cell
 

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

Select range starting at active cell
 

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.

Select range starting at active cell
 

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.

Select range starting at active cell
 

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.