MS considers cells to be in the same current region as long as they are
connected by shared sides or corners. Since you cannot change that you'd
have to write a macro to select cells based on your definition.

--
Jim Rech
Excel MVP
"Microsoft Forum" wrote in message
...
| Hi all,
|
| I have a problem about the Activecell.CurrentRegion property.
|
| Suppose the active sheet has the following data (A - C and 1 - 3 are
column
| and row headings respectively):
|
| A B C
| 1 x y
| 2 z
| 3
|
| If the active cell is on B2 then the activecell.currentregion will return
| A1:B2, which is the one I anticipated.
|
| However if the active cell is on B3 then activecell.currentregion will
| return A1:B3, which is not the one I want. I want the property to return
| only B3. How can I do it, or any other workaround? Thanks for your advice.
|
| Frederick Chow
| Hong Kong.
|
|