Hi Guest,

Try:

Dim Rng As Range

Set Rng = Activecell.CurrentReguon



---
Regards.
Norman


"guest" wrote in message
...
Is there anyway we can programmatically select the data rows and columns
that
the active cell belongs to? Similar what excel charting does.
For example in case of Excel chart you just select a single cell, and say
insert chart it automatically detects the data that the active cell is
part
of and charts it.