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?
|