Excel Macros LMI 26.09.2006 01:31:02 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.?

Re: Excel Macros "Bob Phillips" <bob.NGs[ at ]somewhere.com> 26.09.2006 09:06:11 ACtivecell.CurrentRegion.Select -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "LMI" <LMI[ at ]discussions.microsoft.com> wrote in message news:8F422634-BB1A-4371-9B09-1ABB91847FEC[ at ]microsoft.com... [Quoted Text] > 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.?