ACtivecell.CurrentRegion.Select

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"LMI" wrote in message
...
How can i setup a range macro were if the user dumps 10 cells worth of
data
it will select jsut those 10 cells however if the user dumps 20 cells it
will
adjust the range to select all 20 cells.?