LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to make identical cell datas active to allow changes caprey New Users to Excel 5 December 21st 08 05:42 PM
how do i make a chart follow the active cell mepetey Charts and Charting in Excel 2 October 20th 07 07:29 PM
find text in a cell and make cell 2 cells below that active shark102 Excel Programming 4 October 20th 05 02:41 PM
How to make a particula cell ACTIVE using C# Srini Excel Programming 0 September 12th 05 05:34 PM
Make a particular cell the active one Newbie Excel Programming 3 April 14th 04 04:52 PM


All times are GMT +1. The time now is 05:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"