View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] jpacynski@gmail.com is offline
external usenet poster
 
Posts: 2
Default 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