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

Make the next cell active
 

Hi Jason,

ActiveCell.Offset(1,0).Select

HTH
Carim

Make the next cell active
 

Gotta love groups...

Thanks Carim!

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