| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Make the next cell active
All,
I'm combining 3 different worksheets in to one. It's pretty simple code. The info veries with each worksheet, and all i'm trying to do is make the cell in the next row down active. any thoughts? Here is my basic code: Windows("Weekly.xls").Activate Columns("A:O").Select Selection.Copy Windows("The Process.xls").Activate ActiveSheet.Paste Range("A2").Select Range("A1").Select Selection.End(xlDown).Select What should this line be?? Thanks! Jason |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Make the next cell active
Hi Jason,
ActiveCell.Offset(1,0).Select HTH Carim |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Make the next cell active
Gotta love groups...
Thanks Carim! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Make the next cell active
Hi Jason,
Assuming your sheet names, you don't need to select any of those objects... Workbooks("Weekly.xls").Sheets("Sheet1").Columns(" A:O").Copy Workbooks("The Process.xls").Sheets("Sheet1") HTH -- Regards, Zack Barresse, aka firefytr To email, remove NOSPAM wrote in message oups.com... All, I'm combining 3 different worksheets in to one. It's pretty simple code. The info veries with each worksheet, and all i'm trying to do is make the cell in the next row down active. any thoughts? Here is my basic code: Windows("Weekly.xls").Activate Columns("A:O").Select Selection.Copy Windows("The Process.xls").Activate ActiveSheet.Paste Range("A2").Select Range("A1").Select Selection.End(xlDown).Select What should this line be?? Thanks! Jason |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to make identical cell datas active to allow changes | New Users to Excel | |||
| how do i make a chart follow the active cell | Charts and Charting in Excel | |||
| find text in a cell and make cell 2 cells below that active | Excel Programming | |||
| How to make a particula cell ACTIVE using C# | Excel Programming | |||
| Make a particular cell the active one | Excel Programming | |||
Linear Mode
