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?

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?

Thank you.