Excel Macros

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.?
 
ACtivecell.CurrentRegion.Select

--
HTH

Bob Phillips

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