Defining a range
 

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?

Defining a range
 

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" wrote in message
...
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?

Defining a range
 

Thank you.