select geebee 30.08.2006 21:29:03 hi, I have the following, which selects a range of cells across an Excel row: obj.Sheets("Input").Visible = True obj.Sheets("Input").Activate obj.range("a265:m265").select I need to know how I can simulate pressing the SHIFT, END, DOWN ARROW keys to select down to the last row of entered data. Thanks in advance, geebee

Re: select "Duane Hookom" <DuaneAtNoSpanHookomDotNet> 31.08.2006 03:10:46 Wrong news group. -- Duane Hookom MS Access MVP "geebee" <geebee[ at ]discussions.microsoft.com> wrote in message news:2E860E72-B78C-47A9-8759-56988DC961B4[ at ]microsoft.com... [Quoted Text] > hi, > > I have the following, which selects a range of cells across an Excel row: > > obj.Sheets("Input").Visible = True > obj.Sheets("Input").Activate > > obj.range("a265:m265").select > > > I need to know how I can simulate pressing the SHIFT, END, DOWN ARROW keys > to select down to the last row of entered data. > > Thanks in advance, > geebee >