Defining a range

[JDBAZ]

How do I select a range defined as the currently-selected cell to a cell a
specified number of cells away, both vertically and horizontally?

 

[Rick Rothstein \(MVP - VB\)]

I'm not sure how you will want to specify the new cell's coordinates, so
I'll leave the method and math to you; however, you would use something like
this...

ActiveCell.Resize(5, 3).Select

When executed, the Selection will start with the ActiveCell and be 5 rows
deep by 3 columns across.

Rick

 

[JDBAZ]

Thank you.