Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
select
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
select
try this one:
Range(Selection, Selection.End(xlDown)).Select pls do rate "geebee" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
select
hi,
here is what I have now. This is the code behind a button in ms access: obj.Range("A265").Select Range(Selection, Selection.End(xlToRight)).Select Range("A265:m265").Select Range(Selection, Selection.End(xlDown)).Select Selection.ClearContents I am getting an error message that says runtime error 424: object required. Im not sure what to do. Thanks in advance, geebee "Muhammed Rafeek M" wrote: try this one: Range(Selection, Selection.End(xlDown)).Select pls do rate "geebee" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA: Column Select then Data Select then return to cell A1 | Excel Discussion (Misc queries) | |||
Macro to select cells without a certain value and select a menu it | Excel Worksheet Functions | |||
Using formulas to select cells (Ex: Select every nth cell in a col | Excel Discussion (Misc queries) | |||
In Excel 2000, How do you select the whole of a worksheet (Select. | Excel Discussion (Misc queries) | |||
Select other workbook to select data in a macro. | Excel Programming |